DEV Community

select * from SQL

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

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Parse Oracle SQL in VS Code with Gudu SQL Omni
_8a5b012a1114c57f808deb profile

Parse Oracle SQL in VS Code with Gudu SQL Omni

#database #sql #tooling #vscode
Comments
3 min read
ORM library Ujorm 3.0 is released
pponec profile

ORM library Ujorm 3.0 is released

#news #database #java #sql
Comments 1
1 min read
🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try
ashish_srivastava_e6b8ecc profile

🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try

#sql #database #postgres #dataengineering
Comments
1 min read
PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search
philip_mcclarence_2ef9475 profile

PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

#database #performance #postgres #sql
Comments
4 min read
JDBC vs JPA: Which Should You Use?
chi25 profile

JDBC vs JPA: Which Should You Use?

#java #software #sql #programming
Comments
4 min read
hi all!
rgt0 profile
rgt0

hi all!

#ai #programming #cobol #sql
Comments
1 min read
Refreshing PostgreSQL Materialized Views Without Downtime
data_with_jelimo profile

Refreshing PostgreSQL Materialized Views Without Downtime

#database #performance #postgres #sql
2
Comments
7 min read
The Restart Challenge: Day 02
mk_novice profile

The Restart Challenge: Day 02

#devjournal #django #learning #sql
Comments
1 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀
shreyash_ogale profile

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

#beginners #database #mysql #sql
Comments
2 min read
Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data
vivekdraxlr profile

Multi-Tenant SQL Reporting: How to Show Each Customer Only Their Own Data

#sql #database #postgres #webdev
Comments 1
5 min read
PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained
philip_mcclarence_2ef9475 profile

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql
Comments
4 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types
shreyash_ogale profile

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

#beginners #database #mysql #sql
Comments
2 min read
UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison
digipackhq profile

UPSERT in MySQL, PostgreSQL, SQLite & MS SQL Server — A Complete Comparison

#sql #database #python #beginners
2
Comments
2 min read
How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

78% index disk waste revealed by custom tools
alimafana profile

How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

#postgres #database #performance #sql
15
Comments 5
10 min read
Set-Based Updates in Rails: 4 Hours to 8 Seconds
travelingwilbur profile

Set-Based Updates in Rails: 4 Hours to 8 Seconds

#rails #sql #performance #ruby
4
Comments 3
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.