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.
Building Solid Fundations on Rails Associations

Building Solid Fundations on Rails Associations

8
Comments 1
3 min read
Subtle issues with ORMs, and how to avoid them

Subtle issues with ORMs, and how to avoid them

15
Comments 4
8 min read
NoSQL Document Stores

NoSQL Document Stores

50
Comments 2
4 min read
Unit Test em Stored Procedures (SQL Server) Parte II

Unit Test em Stored Procedures (SQL Server) Parte II

3
Comments
3 min read
Getting started with our PostgreSQL database

Getting started with our PostgreSQL database

8
Comments
4 min read
Can anyone help me out with SQL Server tips and tricks?

Can anyone help me out with SQL Server tips and tricks?

3
Comments 2
1 min read
I wrote a simple trivia hosting platform

I wrote a simple trivia hosting platform

2
Comments 2
1 min read
Buildmystring.com - Generate your string concatenation code

Buildmystring.com - Generate your string concatenation code

6
Comments
2 min read
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
QPP - My final thesis - first part

QPP - My final thesis - first part

2
Comments
2 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
Corona Virus Cases Reporting

Corona Virus Cases Reporting

2
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
loading...