Explores using Java 16's new Unix-domain socket support to connect to a PostgreSQL database, covering setup, the JDBC driver, and alternative clients.
Monthly update on godocs.io launch, SourceHut dark theme, and API 2.0 work for sr.ht services, plus minor project improvements.
An in-depth look at Hash indexes in PostgreSQL, explaining their structure, performance benefits, and use cases compared to B-Tree indexes.
Django Chat podcast episode discussing PostgreSQL full-text search and GeoDjango for mapping projects with contributor Paolo Melchiorre.
A talk on implementing full-text search using Django and PostgreSQL, highlighting its simplicity over dedicated search engines.
A tutorial on Konjection, a helper library built on Knex and Objection.js to simplify database operations and model creation in Node.js.
A guide to quickly exploring and understanding a new PostgreSQL database using psql, covering initial setup and table inspection.
A tutorial on creating and deploying a Ruby on Rails API to Heroku, covering setup, database configuration, and deployment steps.
Analyzes how medium-sized text fields impact PostgreSQL query performance through the TOAST storage mechanism.
A talk on implementing full-text search using only Django and PostgreSQL, following Pythonic principles for simplicity.
A talk on implementing full-text search using only Django and PostgreSQL, presented at DjangoCon Europe 2020.
A comprehensive reference guide for Django covering deployment, REST APIs, database setup, environment variables, and essential commands.
A tutorial on building a Ruby on Rails API with JWT authentication for a user notes application.
A developer's monthly update covering BARE encoding progress, SourceHut infrastructure improvements, and a snippet of low-level I/O code.
A developer shares their experience and lessons learned from giving a technical talk at the online EuroPython 2020 conference.
A talk on implementing full-text search using only Django and PostgreSQL, presented at EuroPython 2020.
A guide on using PostgreSQL's FOR loop to generate test data for development and UI testing.
Introducing DBCore, a tool that generates a complete REST API and admin interface from a PostgreSQL or MySQL database schema.
A guide to automating PostgreSQL database backups using scripts and AWS S3 for secure, reliable cloud storage.
A guide on using pg_dump and pg_restore to backup and restore a PostgreSQL database, crucial for data protection in DevOps.
