DEV Community

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Optimizing the Performance of Django SearchVector with GIN Indexing
azayshrestha profile

Optimizing the Performance of Django SearchVector with GIN Indexing

#django #postgres #performance #coding
5
Comments 1
2 min read
PostgreSQL specific trigram_similar lookups in Django
azayshrestha profile

PostgreSQL specific trigram_similar lookups in Django

#django #postgres #ubuntu
2
Comments
1 min read
Enhance Your Searches with PostgreSQL Trigram Similarity in Django
azayshrestha profile

Enhance Your Searches with PostgreSQL Trigram Similarity in Django

#django #postgres #performance #coding
4
Comments
3 min read
WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB
vdelitz profile

WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

#mysql #postgres #sqlite #mongodb
2
Comments
2 min read
A Guide to Accessing a Remote PostgreSQL Database in Ubuntu Server
azayshrestha profile

A Guide to Accessing a Remote PostgreSQL Database in Ubuntu Server

#postgres #ubuntu #database #devops
5
Comments
3 min read
Carregando dados com Apache HOP & Postgres
deadpunnk profile

Carregando dados com Apache HOP & Postgres

#apachehop #dataengineering #postgres #tutorial
6
Comments
3 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS
marklouisalter profile

OLAP: CUBE, ROLLUP, AND GROUPING SETS

#database #sql #mysql #postgres
5
Comments 1
4 min read
How PostgreSQL's COALESCE Function Simplifies NULL Value Handling
dbvismarketing profile

How PostgreSQL's COALESCE Function Simplifies NULL Value Handling

#postgres
1
Comments
1 min read
🚀 How to Build a Next.js App with React, PostgreSQL, and SportDevs API?
nicosleonardo9 profile

🚀 How to Build a Next.js App with React, PostgreSQL, and SportDevs API?

#nextjs #react #postgres
2
Comments
1 min read
How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?
shiviyer profile

How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

#postgres #mysql #sql
1
Comments
3 min read
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown
marklouisalter profile

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

#sql #mysql #database #postgres
8
Comments
2 min read
ubuntu server create database and create new user with password for there database in postgresql.
pheak_pheasa profile

ubuntu server create database and create new user with password for there database in postgresql.

#ubuntu #postgres
Comments
9 min read
How does Wave Analytics handle data from external databases in PostgreSQL?
shiviyer profile

How does Wave Analytics handle data from external databases in PostgreSQL?

#postgres #sql #dba
Comments
3 min read
Video encoded as emojis⁉️ Stored in a DB? 😱🤯
grahamthedev profile

Video encoded as emojis⁉️ Stored in a DB? 😱🤯

#javascript #postgres #webdev #programming
87
Comments 17
9 min read
Simplified SQL: Harnessing the Power of Aliases
marklouisalter profile

Simplified SQL: Harnessing the Power of Aliases

#sql #database #postgres
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.