Skip to main content

Search

Items tagged with: PostgreSQL


Administration, performances, développement, migration vers #PostgreSQL : voici les dates de nos prochaines sessions, en présentiel ou à distance =>
https://dali.bo/202308_dates_formations
#DBA #développeur #développeuse #SGBD #opensource #formation


Updatable views in PostgreSQL: Why and how?

https://tom.chadw.in/wrote/UpdatableViews

#postgresql #gischat


Another great post from the Crunchy Data folks on using #PostgreSQL as the datastore for real time #analytics / #metrics / #logging (spoiler, they are not even using a huge machine).

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


PGSQLPhriday #008 Roundup! 🤓

Great topic this month, thanks @michristofides for hosting!

https://www.pgmustard.com/blog/pgsql-phriday-008-roundup

#pgsqlphriday #postgres #postgresql


Love #PostgreSQL Looking to work with #MachineLearning and AI? Wanna use them together?

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


Such an innocent looking query... I didn't expect it to do this!

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


FerretDB: Open source MongoDB alternative (#PostgreSQL)

https://blog.ferretdb.io/ferretdb-1-0-ga-opensource-mongodb-alternative/

This website uses cookies to recognize revisiting and logged in users. You accept the usage of these cookies by continue browsing this website.