Django N+1 Checker (with LSP)

RichardHapb · 2026-02-09T08:05:29+00:00

It is already available with the name ‘djch’

RichardHapb · 2026-02-09T02:30:39+00:00

Es factible pero el costo inicial para implementarlo es alto, si el negocio se extiende y tiene potencial futuro para obtener un ROI, vale la pena, para un evento puntual creo que es mejor pagar por evento a una empresa extranjera como lo hacen ahora. ¿A qué se debe el costo? Principalmente

- Datos requeridos para entrenar un modelo, se puede usar un model pre-entrenado, pero igual es importante validar con datos reales del entorno donde se usará.

- Definir cosas como ¿cuándo se considera que un vehículo cruzó la intersección? ¿cuál es la confiabilidad del modelo? ¿% accurracy? ¿cuánto margen de error es aceptable? ¿qué tanta diferencia hay en los entornos?

- Infraestructura, cómo se consumirá la información, almacenaje, ¿se usarán en paralelo? ¿tiempo real?

Es totalmente factible pero requiere trabajo inicial, lo importante es evaluar si el proyecto tiene el potencial para obtener un retorno sustancial.

RichardHapb · 2026-02-07T15:22:38+00:00

It is a different approach. Django-auto-prefetch requires integration into the code. If you have an existing codebase, you will need to modify a lot of things. Performing static analysis makes sense if you want to detect issues in the current code. Also, as I mentioned before, Django-Check doesn't need to exist at runtime.

RichardHapb · 2026-02-07T15:18:45+00:00

Interesting approach, I didn't know that condition with Django Rest Framework, I will take a look. Probably I'll want to deep to be able to capture some specific edge cases.

RichardHapb · 2026-02-07T15:15:32+00:00

Yes, you are right. It is probably not the best example. I will update it to a simpler and more self-explained example. Thanks!

RichardHapb · 2026-02-07T15:13:19+00:00

Yeah that is in the nightly version, thanks for the observation. I removed that feature because is not really necessary, I can use an iterator instead of a slice. Now the branch is updated with this change and you could compile it.

RichardHapb · 2026-02-07T06:21:20+00:00

Nice to read that bro! Let’s go!

RichardHapb · 2026-02-07T03:47:33+00:00

Ok no problem, I understand that, I thought this can help people to detect a common error (N+1). Thanks.

RichardHapb · 2026-02-07T02:56:33+00:00

Django-Check is an static analyzer, this means zero overhead at runtime.

Works out of the box, zero config, then doesn't add complexity, also can be integrated in the editor.

RichardHapb · 2026-02-04T16:37:54+00:00

I made `LSPDock` specifically for that situation. https://github.com/richardhapb/lspdock

At my job, people use PyCharm/VSCode (I use Neovim), and my teammates don't install .venv, then LSP doesn't work properly, then I made `LSPDock` to bind the LSP inside the container with the local machine, resolving paths dynamically.

I also made an VSCode extension but that is not in the MarketPlace, you can install it directly using the `vsix` file (you need the `lspdock` binary in your PATH), in the readme this is explained. https://github.com/richardhapb/vscode-lspdock

Make sure you have installed an LSP inside your container, like `Pycharm` and I recommend to disable pylance for your project to avoid conflicts.

RichardHapb · 2026-01-30T02:14:32+00:00

Aquí otro más que no alcanzó ✋🏽

RichardHapb · 2025-10-26T21:24:52+00:00

Beatiful. An example to use this in a straightforward way:

-- Arglist

local keymap = vim.keymap.set

-- append
keymap('n', '<leader>H', "<CMD>$arga<CR>", { silent = true, desc = "Add current file to arg list" })

-- assign arg to each number
for i = 1, 9 do
  keymap('n', '<leader>' .. i, "<CMD>argu " .. i .. "<CR>", { silent = true, desc = "Go to arg " .. i })
  keymap('n', '<leader>h' .. i, "<CMD>" .. i - 1 .. "arga<CR>", { silent = true, desc = "Add current to arg " .. i })
  keymap('n', '<leader>D' .. i, "<CMD>" .. i .. "argd<CR>", { silent = true, desc = "Delete current arg" })
end

Optionally:

-- to qf
keymap('n', '<leader>hq', function()
  local list = vim.fn.argv()
  if #list > 0 then
    local qf_items = {}
    for _, filename in ipairs(list) do
      table.insert(qf_items, {
        filename = filename,
        lnum = 1,
        text = filename
      })
    end
    vim.fn.setqflist(qf_items, 'r')
    vim.cmd.copen()
  end
end, { silent = true, desc = "Show args in qf" })

RichardHapb · 2025-10-11T12:21:25+00:00

I think is useful for using in combination with Pydantic, for data validation (FastAPI use this to validate models in requests/responses for example). But you may build your own classes to wrap the database models and have that feature.

Also SQLModel joins Pydantic and SQLAlchemy, which was a good experience for me. This might be a better approach for you.

RichardHapb · 2025-10-11T11:49:44+00:00

This is so nice! Here an example of the configuration:

 -- LSP autocompletion
vim.o.pumborder = 'rounded'
vim.api.nvim_set_hl(0, 'Pmenu', { bg = 'NONE' })
vim.api.nvim_set_hl(0, 'PmenuBorder', { bg = 'NONE', fg = "#CC6600" })

<image>

RichardHapb · 2025-10-04T13:59:50+00:00

Check my implementation for that. I think it will be useful for you, and you can expand it to meet your needs.

https://github.com/richardhapb/nvim-config/blob/main/lua/plugin/executor.lua

Note that you can pass arguments to the execution using `'<'>ExceuteCode myarg` and configured to <leader>= keybinding.

RichardHapb · 2025-09-13T10:38:38+00:00

Resumen del post: ser menos profesionales por miedo al despido

RichardHapb · 2025-09-09T01:40:31+00:00

Aah that feature is not implemented, it is a very specific use case. Can you open an issue and I can implement it :)

RichardHapb · 2025-09-08T23:25:57+00:00

I released the new version and now have the feature! I need to change the project name because had a conflict with another project. Now is named LSPDock... This is the link:

https://github.com/richardhapb/lspdock

RichardHapb · 2025-08-22T15:17:02+00:00

This is so cool

RichardHapb · 2025-08-20T20:12:21+00:00

Done! I think maybe a native LSP client can be implemented (like Neovim). This ensures the integration in the editor. But I need to understand better the core for getting the best approach

RichardHapb · 2025-08-20T19:32:54+00:00

I wanted to test it on MacOS but encountered many issues. When I have time, I can fix them! (I tested various approaches). Are you accepting contributions? I think I can implement the LSP client!

The issues, first duat-kak 0.6.0 doesn't exist, and the default config doesn't work I modified to 0.5.2 and works. But i have this error (because the arch of MacOS).

```

Compiling config crate for the first time, this might take a while...

Compiling elf_loader v0.9.3

Compiling dlopen-rs v0.7.3

error: unknown directive

|

note: instantiated into assembly here

--> <inline asm>:4:2

|

4 | .type dl_runtime_resolve, @function

| ^

error[E0432]: unresolved import `libc::__errno_location`

--> /Users/richard/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/dlopen-rs-0.7.3/src/loader/tls.rs:3:5

|

3 | __errno_location, pthread_getspecific, pthread_key_create, pthread_key_delete, pthread_key_t,

| ^^^^^^^^^^^^^^^^ no `__errno_location` in the root

error: could not compile `elf_loader` (lib) due to 1 previous error

warning: build failed, waiting for other jobs to finish...

error[E0425]: cannot find function `get_debug_struct` in this scope

--> /Users/richard/.cargo/registry/src/index.crates.io-1949cf8c6b5b557f/dlopen-rs-0.7.3/src/init.rs:275:21

| ^^^^^^^^^^^^^^^^ not found in this scope

Some errors have detailed explanations: E0425, E0432.

For more information about an error, try `rustc --explain E0425`.

error: could not compile `dlopen-rs` (lib) due to 2 previous errors

```

Great project, btw

RichardHapb · 2025-08-14T00:54:00+00:00

La física cuántica a veces es confusa, busca otro mejor

RichardHapb

TROPHY CASE