cracksmity.dev
Español
L5 · City Terminus Under construction

Jalisk

Internships for Guadalajara students: how well you fit each opening, skill by skill, and what you still need to learn.

OPENED
OCT 2026
COURSE
Databases
LIVE
jalisk.lat
TEAM
Me + XomiDessu
SOURCE
Private
Jalisk openings list with a fit ring per opening (94%, 93%, 84%…), labels like Highly recommended and Required 4/4, and a "What if I learn…?" panel on top with the skills worth the most points.
Openings sorted by fit, with "What if I learn…?" to simulate how much each score would rise.

ROUTE · L5 City · 2 stations

  1. MAY 2026 · Extension underway SistemaIVR
  2. YOU ARE HERE Jalisk

Why it exists

Jalisk gathers tech internship openings in the Guadalajara Metropolitan Area, works out how well each student fits each one, skill by skill, and builds them a study path to close the gap.

PostgreSQL computes the score, not the AI. Each requirement gets a membership degree between 0 and 1 (partial level, sibling technology, semantic equivalent via pgvector), and the final recommendation comes from Mamdani fuzzy inference. That makes it reproducible and explainable: "you're at 67% because you're missing Intermediate PostgreSQL". Claude only turns free text into data and writes the prose.

In PL/pgSQL, that engine took 26.3 s over 20,000 rows. Written in Rust and loaded as a PostgreSQL extension with pgrx, it takes 86 ms, with identical results. The app runs on Rust with Axum and SQLx, uses RLS so nobody can read anyone else's data, and deploys itself to jalisk.lat, rolling back automatically if something fails.

Finding an internship in Guadalajara right now is quite the adventure. I've been through it: since the start of the year I wanted to get into Intel, and I even made myself a roadmap of what I knew and what I was missing. If it worked for me, why not for everyone else?

The project was for Databases, and the idea was mine. I focused on the metro area because that's where most of the tech companies are, and because then the database doesn't have to carry thousands of openings from all over the world. Sometimes limiting scope isn't a lack of ambition: it's optimization.

It was called TechHub, but that domain cost 30 dollars and jalisk.lat cost 2. We had no choice. I build the project; XomiDessu, my teammate, presents it.

Agents built it, with a single mission from me: this has to run in Rust and it has to be blazing fast. That's how the fuzzy engine ended up living inside PostgreSQL, 300 times faster than in SQL.

The professor has a strange system for homework. He's given up on AI, so you ask two AIs for the assignment with the same prompt, paste their answers and add your own conclusions at the end. The assignments are the foundation of the project and can't be removed, but nobody has read them, not even the professor; one reached 100 pages. They live in the repo, in a folder called ai-slop-nobody-reads-but-keeps-the-project-alive.

We have the foundations and the tests pass, but we don't know if it actually works. We need users, and permission from companies like Intel to use their job posting systems. The plan is for CUCEI students to use it, though that's still up in the air.

What it does

"why this score?"

A fit score that explains itself

Every percentage breaks down by skill: Machine Learning at 40% because, even though you don't have it, you know generative AI, which is close.

recursive CTE · topological order

A study path

Steps come out in prerequisite order. Mark one complete and a trigger raises your level and your fit.

26.3 s → 86 ms

The engine, inside PostgreSQL

Fuzzy inference as a Rust extension: 307 times faster than PL/pgSQL, with the same results row by row.

Row-Level Security

Your data is yours

Even if the app had a bug, the database won't return another student's rows. Public analytics use a read-only role.

AI Engineer Intern opening detail: 94% fit, a Highly recommended label at 91 out of 100 and a list of skills with fit bars, including Machine Learning at 40% because you know generative AI.
"Why this score?": each skill with its degree of fit, plus the fuzzy inference recommendation.
Jalisk roadmap toward AI Engineer Intern at Wizeline: a six-week plan, the Machine Learning step with its course and a progress panel at 0%.
The path to an opening, in prerequisite order, with a weekly plan written by the AI.
Jalisk Academia page: cards for active openings, companies, average stipend and remote share, a bar chart of the most requested technologies and a list of technologies requested together.
Academia: the metro-area internship market, queried with a read-only role.

How it's built

30 commits in two days · live at jalisk.lat

01 · WebAxum + AskamaRust from the server to the template; Tailwind with no CDN.
02 · DataPostgreSQL + SQLx24 tables in 3NF, 6 RLS policies, queries checked at compile time.
03 · EngineRust + pgrxMamdani fuzzy inference inside the database.
04 · AIClaude + pgvectorPulls skills out of free text and measures semantic similarity.
  • Axum
  • SQLx
  • Askama
  • PostgreSQL
  • RLS
  • pgvector
  • pgrx
  • lógica difusa
  • GitHub Actions

Logbook

  1. JAN 2026I want to get into Intel and make a roadmap of what I know and what I'm missing.
  2. OCT 2026TechHub in two days: a 3NF schema, the fuzzy engine and the app in Rust.
  3. OCT 2026The engine moves into a PostgreSQL extension: from 26.3 s to 86 ms.
  4. OCT 2026Rebranded to Jalisk over a 2-dollar domain; continuous deployment to jalisk.lat.

What I learned

  • Limiting scope isn't a lack of ambition: it's optimization.
  • Relational logic belongs in SQL, where the optimizer shines; heavy number crunching, compiled.
  • If the AI doesn't decide the score, every number can be explained and defended.
  • Passing tests don't tell you whether anyone will use it.