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.
Search MySQL Like Google Using Match and Full-Text Search

Search MySQL Like Google Using Match and Full-Text Search

20
Comments
7 min read
PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

7
Comments 2
1 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

7
Comments
2 min read
First steps with SQL

First steps with SQL

2
Comments
3 min read
How can i create a CRON operation to add numbers based on timed events in my database.

How can i create a CRON operation to add numbers based on timed events in my database.

6
Comments
1 min read
Dev life is easy with node-mssql

Dev life is easy with node-mssql

16
Comments 1
2 min read
Reimagining the SQL Curriculum: Change How SQL is Taught

Reimagining the SQL Curriculum: Change How SQL is Taught

4
Comments
9 min read
Farewell to our Enterprise License

Farewell to our Enterprise License

5
Comments
4 min read
Let's talk about Views

Let's talk about Views

5
Comments
2 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

122
Comments 5
6 min read
SQLite - a developer's best friend

SQLite - a developer's best friend

28
Comments 7
8 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

38
Comments 1
5 min read
SQL Review - How to create an ERD in MySQL

SQL Review - How to create an ERD in MySQL

4
Comments
1 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

12
Comments
5 min read
Announcing EFCore.FSharp

Announcing EFCore.FSharp

12
Comments 1
3 min read
Foreign Keys in MySQL, NoSQL, NewSQL (YugaByteDB)

Foreign Keys in MySQL, NoSQL, NewSQL (YugaByteDB)

1
Comments
11 min read
How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

7
Comments 5
2 min read
SQL tips that will make you productive from day1 at your job.

SQL tips that will make you productive from day1 at your job.

4
Comments
1 min read
Understanding ActiveRecord inner joins

Understanding ActiveRecord inner joins

10
Comments
7 min read
PostgreSQL kümelemede Patroni kullanımı

PostgreSQL kümelemede Patroni kullanımı

12
Comments
5 min read
The Wrong Migration

The Wrong Migration

6
Comments
3 min read
Python with MySQL

Python with MySQL

5
Comments
7 min read
Build a fuzzy search with PostgreSQL

Build a fuzzy search with PostgreSQL

14
Comments 1
5 min read
Database Naming Standards

Database Naming Standards

334
Comments 21
6 min read
EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

9
Comments
5 min read
loading...