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.
Daily Commit Counts as a Terminal Graph w/ Emojis 🚀

Daily Commit Counts as a Terminal Graph w/ Emojis 🚀

6
Comments
2 min read
Apply Reference table to the Rails STI type/Polymorphic type/enum/inclusion validated columns

Apply Reference table to the Rails STI type/Polymorphic type/enum/inclusion validated columns

5
Comments
4 min read
What do you use for full-text search these days?

What do you use for full-text search these days?

9
Comments 11
1 min read
Gerando um totalizador acumulado por linha sem usar cursor.

Gerando um totalizador acumulado por linha sem usar cursor.

3
Comments
2 min read
Selecting an Application Database

Selecting an Application Database

21
Comments 8
4 min read
The What and Why of PostgreSQL Views 00:00

The What and Why of PostgreSQL Views

37
Comments 8
1 min read
What I read this week?

What I read this week?

7
Comments
1 min read
Bitmasks in SQL

Bitmasks in SQL

10
Comments
1 min read
Dirty Dynamic SQL

Dirty Dynamic SQL

10
Comments
2 min read
Defensive coding in SQL

Defensive coding in SQL

11
Comments 1
1 min read
Correlation IDs in Django SQL

Correlation IDs in Django SQL

18
Comments
4 min read
Building a Slack Bot that Writes Custom Queries against your Database

Building a Slack Bot that Writes Custom Queries against your Database

4
Comments
3 min read
Tutorial: Automate Text Messages when Database Conditional Changes

Tutorial: Automate Text Messages when Database Conditional Changes

19
Comments
3 min read
Extending the Aerospike JDBC driver with UDFs

Extending the Aerospike JDBC driver with UDFs

6
Comments 1
2 min read
Functions supported by the Aerospike SQL driver

Functions supported by the Aerospike SQL driver

3
Comments 2
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.