Bookmarks with tag "db", page 6 of 7

Postgresql: Conditionally unique constraint
db postgres
2020-05-06 11:49
Storing Passwords Securely With PostgreSQL and Pgcrypto
Learn how to make sure that your users' passwords are safe and secure in your PostgreSQL database.
db postgres security
2020-04-27 16:13
EVAL in Redis
Executes a server-side Lua script.
db redis
2020-04-24 08:17
PGAudit
db postgres
2020-04-17 13:21
Why you (probably) don't need PostGIS
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.
db geo postgres
2020-04-10 20:30
Using PostgreSQL with Go
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.
db go postgres
2020-02-16 14:02
postgreSQL concurrently change column type from int to bigint
db postgres
2020-01-03 11:39
MinIO
MinIO's High Performance Object Storage is Open Source, Amazon S3 compatible, Kubernetes Native and is designed for cloud native workloads like AI.
db image-processing video-processing
2019-12-22 13:50
UUID Primary Key in Rails 6 with PostgreSQL and ActiveRecord
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.
db postgres ruby
2019-11-28 20:32
Discovering less-known PostgreSQL 12 features
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.
db postgres
2019-11-28 19:51
The Definitive Guide To InfluxDB In 2019
A complete guide explaining every InfluxDB concepts in-depth and providing real-world applications of this new technology.
db
2019-11-16 10:40
Casecommons/pg_search
pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search
db postgres
2019-10-21 08:41
KeyDB - The Faster Redis Alternative
db redis
2019-10-07 19:42
SQL Window Functions: NTILE, LAG, and LEAD
SQL Server Window Functions are incredibly powerful and allow us to access a total from another row and bucket data to show top performers.
db
2019-09-04 13:22
SQL Window Functions: RANK and Running Totals
SQL window functions allow us to see the rows in a table with a new column showing a running total, rank or moving average.
db
2019-09-04 13:17
PostgreSQL Window Functions
db postgres
2019-08-01 13:14
Mastery with SQL
Over 60 HD videos and 150 exercises to learn modern SQL with this hands-on practical course built for the busy learner
db
2019-06-24 13:33
OVERLAPS Operator in PostgreSQL
How to check if two datetime ranges overlap in PostgreSQL.
db postgres
2019-06-22 20:27
Lessons learned scaling PostgreSQL database to 1.2bn records/month
db performance postgres
2019-06-22 15:46
Optimizing Postgres Column Order
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?
db performance postgres
2019-06-22 15:45