~postgresweekly | Bookmarks (153)
-
Ibis
Ibis 8.0: A Dataframe Framework for Python — Provides a universal interface for data wrangling in...
-
GitHub - theory/pgenv: PostgreSQL binary manager
pgenv: Postgres Binary Manger for the Shell — Makes it simpler to build and run different...
-
GitHub - f-prime/pgtera: A PostgreSQL extension for rendering the Tera HTML templating language.
PGTera: Extension to Render Tera HTML Templates — Tera is a Jinja2-inspired template engine for Rust,...
-
pgvector 0.6.0: 30x faster with parallel index builds
pgvector 0.6.0: Now ~30x Faster with Parallel Index Builds — The pgvector vector similarity search extension...
-
Instant Realtime GraphQL APIs on PostgreSQL database
Instant Realtime GraphQL APIs on PostgreSQL with Hasura — Connect Hasura to your PostgreSQL database and get...
-
Multi-Database Support in DuckDB
DuckDB's Multi-Database Support — DuckDB is an SQLite-esque in-process DBMS but focused on OLAP use cases....
-
JSON and SVG from PostGIS into Google Sheets | Crunchy Data Blog
Getting JSON and SVG from PostGIS into Google Sheets — A walk through using pg_featureserv to...
-
Load StackOverflow’s StackExchange data in Postgresql®
How to Load Stack Overflow's StackExchange Data into Postgres — It’s an interesting process in itself,...
-
Partitioning Postgres tables by timestamp based UUIDs
Partitioning Postgres Tables by Timestamp Based UUIDs — A story from the Elixir forum about partitioning...
-
GitHub - cybertec-postgresql/pg_show_plans: Show query plans of all currently running SQL statements
pg_show_plans: Show Query Plans of All Running Statements — Lets you get live access via SELECT...
-
extension-ecosystem-jobs-tools.md
Towards an Ideal Postgres Extension Ecosystem — Tembo hired David Wheeler, creator of PGXN, to work...
-
GitHub - fabianlindfors/reshape: An easy-to-use, zero-downtime schema migration tool for Postgres
Reshape 0.7: A Zero-Downtime Schema Migration Tool — During a migration, Reshape ensures both the old...
-
One PID to Lock Them All: Finding the Source of... | Crunchy Data Blog
One PID to Lock Them All: Finding the Source of the Lock — One process can...
-
Postgres FM | pgvector
▶ Jonathan Katz on pgvector — Postgres core team member Jonathan Katz went on the Postgres.fm podcast...
-
Tuning Autovacuum for best Postgres performance
eBook: Tuning Autovacuum for Best Postgres Performance — Learn about tuning settings for scheduling and performance,...
-
POSETTE: An Event for Postgres 2024
POSETTE: Citus Con Renames for 2024 — Microsoft has run the virtual Citus Con event for...
-
How to use PostgreSQL® SUBSTRING
🍕 How to Use SUBSTRING — String slicing and dicing.. along with a little pizza, in this case.
-
Apache AGE
Apache AGE 1.5rc: A Graph Extension for Postgres — AGE provides graph database functionality (by way...
-
GitHub - ANXS/postgresql: Fairly full featured Ansible role for Postgresql.
A 'Fairly Full Featured' Ansible Role for Postgres — An Ansible 2.4+ role that installs and...
-
pgmoneta
pgmoneta: A Backup / Restore Solution for Postgres — Formerly a Red Hat project, but now...
-
GitHub - supabase/supa_audit: Generic Table Auditing
supa_audit: Generic Table Auditing for Postgres — A generic solution for tracking changes to tables’ data...
-
GitHub - laurenz/oracle_fdw: PostgreSQL Foreign Data Wrapper for Oracle
oracle_fdw: A Foreign Data Wrapper for Oracle Database — Provides efficient access to Oracle databases, including...
-
Happy New Year: GPT in 500 lines of SQL - EXPLAIN EXTENDED
Implementing GPT in 500 Lines of SQL — When an article pitches itself as demonstrating ‘a...
-
Steampipe | select * from cloud;
Steampipe: Query Your Cloud Services with SQL — Use SQL to query and even join across...