Bookmarks with tag "db", page 6 of 8
A lightweight, framework-agnostic database migration tool.
YouTube-like Short IDs as Postgres Primary Keys.
In this tutorial, you will learn about the PostgreSQL temporary table and how to manage it using the CREATE TEMP TABLE and DROP TABLE statements.
Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more.
TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.
Metabase business intelligence, dashboards, and data visualization tools. Dig deeper into your data with open source, no SQL tools for data visualization.
The Sequel ORM offers a powerful API for building SQL expressions in Ruby. In this article I'll explain how it works and show how it can improve the readability of your queries.
Many apps require database timestamps whenever a database record is created or updated. Here's how you can use triggers to automatically update timestamps in PostgreSQL
Learn how to make sure that your users' passwords are safe and secure in your PostgreSQL database.
Executes a server-side Lua script.
Rebased Team writing about tech we use. Languages, frameworks, libraries, tools. Certified for 0% fluff. PostGIS is a fantastic, battle-tested suite of GIS extensions for Postgres. It handles most aspects of it, and is widely used, for example in OpenStreetMap’s Mapnik. But for your project, it’s most likely overkill. In a Q and A fashion, let’s discuss reasons for (not) using it.
A series covering everything needed to install and start using PostgreSQL with Go's standard libraries, followed by a tour of some popular Golang ORMs.