Full-text search engine with PostgreSQL (part 2): Postgres vs. Elasticsearch(xata.io)

71 points by rw-access 3 years ago | 8 comments

Postgres Webhooks with Pgstream(xata.io)

145 points by mebcitto 2 years ago | 20 comments

Introducing pgzx: create PostgreSQL extensions using Zig(xata.io)

133 points by eatonphil 2 years ago | 36 comments

Putting DuckDB in Postgres to Query Iceberg(blog.paradedb.com)

72 points by philippemnoel 2 years ago | 17 comments

SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

Pgroll: zero-downtime, reversible schema migrations for Postgres(xata.io)

276 points by ksec 3 years ago | 135 comments

A search engine in 80 lines of Python(alexmolas.com)

564 points by alexmolas 2 years ago | 88 comments

Blog post walking through building a simple search engine from scratch in about 80 lines of Python, motivated by small website discoverability.

What I wish someone told me about Postgres(challahscript.com)

389 points by todsacerdoti 1 year ago | 161 comments

A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.

PostgreSQL and UUID as Primary Key(maciejwalkowiak.com)

387 points by taubek 2 years ago | 296 comments

A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.

PostgreSQL for Everything(raphaelbauer.com)

412 points by karlmush 2 months ago | 238 comments

A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.

Go ahead, self-host Postgres(pierce.dev)

635 points by pavel_lishin 10 months ago | 373 comments

A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.

ParadeDB Search Performance Improvements(paradedb.com)

54 points by craigkerstiens 25 days ago | 9 comments

ParadeDB blog post describing search performance improvements in its Postgres-based search extension.