Discuss everything SQL or database relatedPostgres has many extensions:- Query geospatial data:https://postgis.net/- Vector similarity search:https://github.com/pgvector/pgvector- Cron in the DB for scheduling shit:https://github.com/citusdata/pg_cron- Deploy a REST API to make Postgres your entire backend.https://docs.postgrest.org/en/v16/Some other interesting open source DBs:https://duckdb.org/https://www.xtdb.com/https://www.datomic.com/ (similar to XTDB)https://www.yugabyte.com/ (very similar to Postgres, but automatically scales across numerous servers, preserving ACID)>he doesn't use a 4th Generation Languagehttps://www.youtube.com/watch?v=XaC1rQZ_LKs
What's a good way to get SQL experience for jobs that require it?
>>109606305does elephant sql have good index search? better than es?I hate es.
>>109606397think of any business problem and model it using SQL tables, then write functions (Postgres has PL/PGSQL, and entire procedural language, built-in, you can even write JS, Python, Java, etc., see https://wiki.postgresql.org/wiki/PL_Matrix) to deal with those tables.then have your backend in Python or whatever just do `select the_function(...)`, very trivial to deal with, and very efficient because your business logic lives right next to the data.>>109606495idk about minute performance shit, Postgres has served insane workloads and is extensible enough to build your own solution using something like PGRX with Rust/raw C.
