Search
Items tagged with: postgresql
https://dali.bo/202308_dates_formations
#DBA #développeur #développeuse #SGBD #opensource #formation
https://tom.chadw.in/wrote/UpdatableViews
#postgresql #gischat
Updatable views in PostgreSQL: Why and how?
A technique useful both in relational spatial datasets and when you can’t change the structure of your databasetom.chadw.in
#postgres #postgresql #gischat #postgis #h3
https://blog.rustprooflabs.com/2023/05/postgis-h3-v4-refresh
Once again the Pousty Law of Database:
Start with PostgreSQL, then if you run into a problem, go back and read the docs, try again with PostgreSQL, repeat at least twice, ok now you can think about a different datastore
https://www.crunchydata.com/blog/building-customer-facing-real-time-dashboards-with-postgres
#IsThereAnythingPostgresCantDo
Building Customer-Facing Real-Time Dashboards with Postgres
Postgres can be a great back end to powering your customer-facing analytics. Craig gives an overview of getting started with a metrics schema and then powering up to performance.Crunchy Data
Great topic this month, thanks @michristofides for hosting!
https://www.pgmustard.com/blog/pgsql-phriday-008-roundup
#pgsqlphriday #postgres #postgresql
PGSQL Phriday #008 roundup and review!
A couple of weeks ago, I invited folks to blog about pg_stat_statements , as I was hosting the eighth monthly PGSQL Phriday. It was fun seeing the posts roll in last week— I’m so grateful to everyone who got involved.Michael Christofides (pgMustard)
Look no further than #pgvector
https://github.com/pgvector/pgvector
Allows you to store and index vectors as well as do vector math and distance calculations - all in THE BEST database in the universe.
Hat tip to this blog post for bringing it to my attention
https://www.crunchydata.com/blog/whats-postgres-got-to-do-with-ai
#sql #isThereAnythingPostgresCantDo
GitHub - pgvector/pgvector: Open-source vector similarity search for Postgres
Open-source vector similarity search for Postgres. Contribute to pgvector/pgvector development by creating an account on GitHub.GitHub
One table has 500 rows, the other has 381k. Table stats are accurate. The planner still decides it will return 39M rows, roughly 20% of what a cartesian join. The screenshot is from pgMustard, plan here: https://app.pgmustard.com/#/explore/486276b3-d9e5-4bc8-a1eb-a3a23cd1caf4?highlighted=0
SELECT *
FROM store_potential_customers p
INNER JOIN osm.road_line r
ON r.route_motor
WHERE p.geom <-> r.geom < 100
;
@michristofides
#postgis #postgresql #postgres #performance
https://blog.ferretdb.io/ferretdb-1-0-ga-opensource-mongodb-alternative/
Announcing FerretDB 1.0 GA - a truly Open Source MongoDB alternative | FerretDB Blog
After many months of development, FerretDB is now production-ready. We are excited to announce the general availability of FerretDB v1.0.blog.ferretdb.io
Un grand merci aux conférenciers et conférencière : Arnaud, Alain, Cédric, Ronan, Nicolas B., @pgstef , Melanie et Nicolas G.
#conférences #PostgreSQL #SGBD #DBMS #opensource #logicielsLibres #replay
