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.
SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle
michaelnocito profile

SQL Comment Syntax by Database: MySQL, PostgreSQL, SQL Server, SQLite, Oracle

#sql #database #tutorial #beginners
Comments
5 min read
COMMENT ON TABLE: How to Store a Table Description in the Database Itself
michaelnocito profile

COMMENT ON TABLE: How to Store a Table Description in the Database Itself

#sql #database #tutorial #beginners
Comments
6 min read
Why I Stopped Rushing to Machine Learning and Started with SQL Instead!
shreyas_s_cf15e23eb1cbcbc profile

Why I Stopped Rushing to Machine Learning and Started with SQL Instead!

#datascience #learning #machinelearning #sql
1
Comments
2 min read
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
nunc profile
Nunc

Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.

#showdev #ai #oracle #sql
Comments
5 min read
MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]
make-wp-fast profile

MariaDB 10.6 to 13.0 for WordPress: Only One Upgrade Actually Does Anything [Benchmark]

#database #performance #sql #wordpress
Comments
10 min read
Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration
tbson87 profile

Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration

#database #documentation #sql #postgres
Comments 1
7 min read
The Night an AI-Generated SQL Query Locked My Production Table
dataio_4921 profile

The Night an AI-Generated SQL Query Locked My Production Table

#sql #ai #database #testing
Comments 1
3 min read
We caught a SQL injection with an offline AI security scanner — here's the exact query it found
jomynn profile

We caught a SQL injection with an offline AI security scanner — here's the exact query it found

#ai #javascript #security #sql
Comments 1
3 min read
Is Supabase Actually a Database?
surajsrggupta profile

Is Supabase Actually a Database?

#sql #supabase #appwritehack #webdev
Comments
5 min read
Building my first database with SQL: a library project
derick_lopes_c748a3f163e7 profile

Building my first database with SQL: a library project

#sql #computerscience
Comments
5 min read
Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights
lucasitpro profile

Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights

#snowflake #dataengineering #sql #cloud
Comments
2 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted
tbson87 profile

Circular Foreign Keys: Why the First Row Cannot Be Inserted

#database #sql #postgres #mysql
Comments
10 min read
PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones
tbson87 profile

PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

#database #postgres #sql #orm
Comments
8 min read
Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table
sike_ren_f38951df83469817 profile

Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table

#privacy #nextjs #webdev #sql
Comments
4 min read
Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours
souleyman_thiao_5e9e61267 profile

Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours

#sql #poo #webdev #french
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.