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 101: How To Select Data From Databases Using SQL

SQL 101: How To Select Data From Databases Using SQL

7
Comments
4 min read
Search MySQL Like Google Using Match and Full-Text Search
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

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

SQLite - a developer's best friend

28
Comments 7
8 min read
Emacs as SQL client with LSP
Cover image for 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
Cover image for 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
Cover image for 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.
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for Build a fuzzy search with PostgreSQL

Build a fuzzy search with PostgreSQL

14
Comments 1
5 min read
Database Naming Standards
Cover image for Database Naming Standards

Database Naming Standards

339
Comments 21
6 min read
loading...