Il n'y a pas de questions bêtes
Jean-Pierre Lambelet
The official postgres Docker image does not include pgvector. To run PostgreSQL with pgvector locally, use the pgvector/pgvector image: it is the same postgres image, with the extension already installed. Here is a minimal pgvector docker compose file, tested with PostgreSQL 18. The pgvector docker compose file services: db: image: pgvector/pgvector:pg18 environment: POSTGRES_USER: app POSTGRES_PASSWORD: … Read more
In a vector search, you often want some documents to count more than others. An official page should come before an old PDF, an up-to-date page before a stale archive. The easy way seems to be putting that weight straight into the sort. SELECT id, weight * (1 – (embedding <=> :q)) AS score FROM … Read more
On a chatbot running on a local council website, a very simple question produced a wrong answer: who looks after the finances? The bot replied with a name, a role, and the present tense. The name was real. The role was correct, but it was correct in 2019: the person had left the executive at … Read more
Imagine someone who has read every university library in Switzerland. They can answer almost any general knowledge question. But if you ask them what happened at your place last week, or what’s in your internal documents, they have no idea. They weren’t there, and no one showed them. That’s RAG explained simply: the gap this … Read more
I recently opened WhatsApp Web and counted: 52 conversations where someone was waiting on a reply from me, lost in hundreds of group chats and notifications. The native filter strip (All / Unread / Favorites / Groups) does not have a “to reply” view. Unread only catches genuinely unread messages, not the ones I opened … Read more
How to prevent LLM hallucination on contact data by injecting a verified registry into the system prompt.
On PostgreSQL, a column whose name contains an uppercase letter must be wrapped in double quotes to be read or modified. Syntax and best practice to avoid this common pitfall.
In Symfony you can define some configuration in the .env file. To be sure of the value the program actually receives at runtime, there is the following command php bin/console debug:container –env-var=DATABASE_URL –env=test With this command you can easily see the value Symfony uses php bin/console debug:container –env-var=DATABASE_URL Symfony Container Environment Variables ======================================= // Displaying … Read more
When using Doctrine, it is sometimes important to find where an SQL query is executed. Just turn on profiling_collect_backtrace on the connection, in the development configuration (config/packages/dev/doctrine.yaml): doctrine: dbal: connections: default: profiling_collect_backtrace: true Keep it for development only: collecting the call stack on every query is expensive. It relies on profiling, which is on by … Read more
To create a table in Drupal 7, you can use the “my_module_update_7000” hook in the “my_module.install” file. The datetime type is unfortunately not mapped, which is why you have to use the “mysql_type” key const MY_MODULE_TABLE_NAME = ‘my_module_table’; function get_my_module_schema(): array { return [ ‘description’ => ‘description’, ‘fields’ => [ ‘id’ => [‘type’ => ‘serial’, … Read more