Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Nov 27 '24

Working with PostgreSQL Date and Time Functions

#database #postgres #analytics #sql

3 min read

Ayra Jett for Bytebase

Nov 26 '24

🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

#api #gitops #sql #database

6 min read

Nov 26 '24

SUBSTR function in Oracle

#webdev #sql #oracle #data

1 min read

Nov 26 '24

17 Practical Examples of the CREATE TABLE Statement

#oracle #sql

1 min read

fael

Nov 25 '24

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

#node #postgres #sql #fintech

4 min read

Nov 25 '24

Statement Level Trigger vs Row Level Trigger

#sql #webdev #database #devops

2 min read

Aditi Bindal for NodeShift

Nov 24 '24

How to Install PostgreSQL on Ubuntu 22.04 LTS

#postgres #database #sql #webdev

10 min read

Nov 17 '24

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

#mysql #sql #webdev #programming

4 min read

Nov 23 '24

Day 2 of SQL Series || Basic Commands

#sql #tutorial #beginners #mysql

3 min read

Nov 16 '24

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

#mysql #webdev #sql #programming

13 min read

Nov 22 '24

ACID Transactions in System Design

#systemdesign #database #sql #career

5 min read

Nov 21 '24

Day 1 SQL Series || Introduction to SQL

#webdev #database #sql #beginners

3 min read

Jasmine Mae for Fermyon

Nov 22 '24

Automating API endpoint testing with Spin

#api #sql #github

5 min read

Oct 18 '24

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

#relational #sql #mysql #webdev

3 min read

Nov 20 '24

Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

#java #beginners #sql #hibernate

2 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.