Bookmarks with tag "postgres", page 4 of 4
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.
UUID also known as GUID is an alternative primary key type for SQL databases. It offers some non-obvious advantages compared to standard integer-based keys. Rails 6 release fresh out of beta introduces a new feature in ActiveRecord that makes working with UUID primary keys more straightforward. In this tutorial, we will dive deep into UUIDs with all their cons and pros.
Get to know and learn how to use some less-known features of Version 12 of PostgreSQL. You'll surely discover something new for yourself.
pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search
How to check if two datetime ranges overlap in PostgreSQL.
Columns represent our data, and their order of definition directly impacts storage. What if there were a way to optimize this for real, tangible benefit?
In this tutorial, you will learn how to use the PostgreSQL CREATE PROCEDURE statement to create new stored procedures.
Web site created using create-react-app