Stop managing 7 databases. Stop paying for 7 services. Stop waking up at 3 AM for 7 reasons. PostgreSQL can replace Redis, Elasticsearch, MongoDB, Kafka, and more — with the same algorithms.

Lightweight WASM Postgres

PgTune - Tuning PostgreSQL config by your hardware

An interesting API/Server for Typescript that makes a Postgres DB directly accessible on the client side with caching. Security model relies on permission, and data is then stored on the browser cache, but this means you could do without a backend middleware for quite a few operations. Works with an existing schema

A comprehensive collection of practical PostgreSQL how-to guides covering database management, optimization, troubleshooting, and best practices. Guide categories:

• Performance & query optimization
• Database administration
• Monitoring & troubleshooting
• Schema design & DDL operations
• Development tools & techniques
• Advanced topics
• Miscellaneous

How to perform keyword search on columns in postgresql using tsvector and tsquery. This allows us to perform Full-Text-Search for keywords in database.

pgcli is a command-line PostgreSQL client with auto-completion and syntax colouring, built for quick interactive querying directly from the terminal. Features include:

• Context-aware suggestions that surface tables, columns or keywords as you type
• Fuzzy filter on history
• Syntax highlighting
• Multi-line editing
• Smart pager selection
• Auto switch to vertical output when a result exceeds terminal width
• Configurable row-limit prompt
• Primitive support for psql slash commands
• Optional warnings before destructive statements
• Rich configuration file for prompts and colours

pgModeler is an open-source, cross-platform database modeler designed specifically for PostgreSQL. Aiming to be a reference database design tool in the FOSS ecosystem for PostgreSQL, it offers a robust and feature-rich interface that enables efficient data modeling and rapid code deployment to servers. One of its standout features is reverse engineering, which allows users to generate visual representations of existing databases, making it easier to understand and modify complex structures. Additionally, pgModeler supports the generation of SQL scripts to synchronize a database model with an actual database through a process known as diff. Beyond its core modeling capabilities, the tool includes a minimalist yet functional database server administration module. This module enables users to execute SQL commands, browse databases, and handle data through a simple and intuitive user interface.

A list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

remove app logic outside of cient app and inside of postgresDB

taylor.town about

The goal of this repository made by Daniel Olshansky is to demonstrate how to use Postgres for everything. Topics include: Blog Posts & Articles, Cron Jobs, Embeddable Postgres, Message Queues, Analytics, GIS & Mapping, Audit Logs, Access Control & Authorization, Search, Time Series, Column Oriented, NoSQL, Graph Data, Foreign Data, HTTP, API Platforms, GraphQL and Alternative Query Languages, Events, Replication, CDC, Caching, Unit Tests, HTML & Applications, Migrations, Performance Tuning, Monitoring, Scaling & Storage, User Interfaces & Dashboards, Visualization, Package Management, Language Servers,Data Privacy & Security (or Data Masking)

Stream data out of your Postgres database. Contribute to sequinstream/sequin development by creating an account on GitHub.