Hacker

How to Migrate from Oracle to PostgreSQL

This whitepaper covers experience of database migration from Oracle to PostgreSQL made by Intelligent Converters for a large cargo delivery company. The key reason of migration was reducing cost of ...
GitHub

A Common Lisp PostgreSQL programming interface

Efficient communication with the database server without need for foreign libraries. Support for UTF-8 on Unicode-aware Lisp implementations A syntax for mixing SQL and Lisp code Convenient support ...
Hacker

SQL vs T-SQL: Key Differences and Use Cases

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...
InfoWorld

Using PostgreSQL as a vector database in RAG

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...
GitHub

pg_paxos

This PostgreSQL extension provides a basic implementation of the Paxos algorithm in PL/pgSQL and basic table replication through Paxos. Warning: pg_paxos is in an early stage, consider it experimental ...
InfoWorld

Put business logic in the application, not the database

We’ve all done it. We needed to pull data out of an SQL database, and the query we needed to pull out data was a complex query with multiple table joins, complex filter criteria, and sophisticated ...