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.
Introduction to SQL Using PostreSQL

Introduction to SQL Using PostreSQL

3
Comments
9 min read
Text-to-SQL: A Developer’s Zero-to-Hero Guide

Text-to-SQL: A Developer’s Zero-to-Hero Guide

5
Comments
9 min read
Oracle Database 23ai : Group By and Having using Column Aliases

Oracle Database 23ai : Group By and Having using Column Aliases

Comments
2 min read
Get the Records after and before the Searched One — From SQL to SPL #18

Get the Records after and before the Searched One — From SQL to SPL #18

7
Comments 2
2 min read
Introducing Zaturn MCP

Introducing Zaturn MCP

Comments
1 min read
SQL Statement

SQL Statement

Comments
9 min read
How to Install and Use SQLmap on Android Termux

How to Install and Use SQLmap on Android Termux

2
Comments
6 min read
Deadlock? NO, Time Leap!

Deadlock? NO, Time Leap!

Comments
3 min read
How to supplement the missing capabilities of database SQL with esProc

How to supplement the missing capabilities of database SQL with esProc

6
Comments
6 min read
Implementing temporal table auditing in software development projects

Implementing temporal table auditing in software development projects

Comments
8 min read
How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

5
Comments
8 min read
How To Set Up Multiple Datasources in Spring Boot 3

How To Set Up Multiple Datasources in Spring Boot 3

4
Comments
8 min read
Why You Shouldn’t Invest In Vector Databases?

Why You Shouldn’t Invest In Vector Databases?

1
Comments 1
6 min read
2nd,Create Tables In Supabase

2nd,Create Tables In Supabase

Comments
1 min read
Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

5
Comments
14 min read
Mastering SQL Server CONTAINS for Advanced Text Search

Mastering SQL Server CONTAINS for Advanced Text Search

Comments
1 min read
Twitter Stuck Signing Up? No Email, Phone Field Broken?

Twitter Stuck Signing Up? No Email, Phone Field Broken?

Comments
2 min read
Postgresql soft-delete strategies: balancing data retention

Postgresql soft-delete strategies: balancing data retention

Comments
3 min read
Importing month names into SQLite3 can be useful

Importing month names into SQLite3 can be useful

Comments 3
3 min read
Build a Shared-Nothing Distributed Queue with SQLite and Python

Build a Shared-Nothing Distributed Queue with SQLite and Python

Comments
2 min read
Convert LONG to LOB on import(23ai)

Convert LONG to LOB on import(23ai)

1
Comments
2 min read
Statistics by time window: SPL VS SQL #16

Statistics by time window: SPL VS SQL #16

6
Comments
3 min read
Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

7
Comments 1
2 min read
Study Notes 6.11-12: Kafka ksqlDB, Connect & Schema Registry

Study Notes 6.11-12: Kafka ksqlDB, Connect & Schema Registry

Comments
7 min read
Indexing in PostgreSQL: Pros, Cons, and Best Practices

Indexing in PostgreSQL: Pros, Cons, and Best Practices

2
Comments
3 min read
loading...