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.
Using Docker & Docker Compose to Improve Your Full Stack App Development

Using Docker & Docker Compose to Improve Your Full Stack App Development

2
Comments
8 min read
Sequelize: Like Mongoose but for SQL

Sequelize: Like Mongoose but for SQL

3
Comments
8 min read
SQL on Rails concept

SQL on Rails concept

25
Comments
8 min read
SQL: Where spaces may not matter

SQL: Where spaces may not matter

60
Comments 8
4 min read
Impact of Bind Variables on SQL Performance

Impact of Bind Variables on SQL Performance

19
Comments
4 min read
Generar código autonumérico con reinicio anual

Generar código autonumérico con reinicio anual

7
Comments
3 min read
JDBCを利用してJavaからデータベースにアクセスする方法

JDBCを利用してJavaからデータベースにアクセスする方法

6
Comments
2 min read
Query Fun

Query Fun

11
Comments
2 min read
What is 'impedence mismatch' in the context of sql databases ?

What is 'impedence mismatch' in the context of sql databases ?

9
Comments 4
1 min read
PostgreSQLでSQL実行までのチュートリアル

PostgreSQLでSQL実行までのチュートリアル

12
Comments 2
1 min read
BeckDesignRules for Database Developers Part 1: Passes the tests

BeckDesignRules for Database Developers Part 1: Passes the tests

13
Comments 4
11 min read
QuerySet Filters on Many-to-many Relations

QuerySet Filters on Many-to-many Relations

11
Comments
4 min read
Concatenating MySQL Results with Group_concat and Concat_ws

Concatenating MySQL Results with Group_concat and Concat_ws

6
Comments
3 min read
Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 3: Postgres

Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 3: Postgres

20
Comments
6 min read
Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 2: Routing

Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 2: Routing

13
Comments 1
8 min read
Fixing relational DB mistakes: wrong keys

Fixing relational DB mistakes: wrong keys

13
Comments 3
10 min read
Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 1

Building RESTful Web APIs with Dart, Aqueduct, and PostgreSQL — Part 1

61
Comments 13
5 min read
The Day Everyone Turned Into Michael Johnson. A Lesson In F5.

The Day Everyone Turned Into Michael Johnson. A Lesson In F5.

26
Comments 3
4 min read
Uniones de tablas en SQL

Uniones de tablas en SQL

8
Comments
10 min read
What I learned from only using Select in PostgreSQL

What I learned from only using Select in PostgreSQL

75
Comments 6
4 min read
PostgreSQL: JSON aggregation

PostgreSQL: JSON aggregation

6
Comments
2 min read
Unit Testing. Logic in Domain vs Logic in SQL

Unit Testing. Logic in Domain vs Logic in SQL

10
Comments 4
2 min read
SQL Server Reporting Services: Lessons Learned from the Trenches

SQL Server Reporting Services: Lessons Learned from the Trenches

21
Comments 3
5 min read
On Being New and Getting Good

On Being New and Getting Good

17
Comments 3
2 min read
Moving individual MySQL tables on disk

Moving individual MySQL tables on disk

27
Comments 1
7 min read
Should I go NoSQL or SQL for my specific app case? Or both?

Should I go NoSQL or SQL for my specific app case? Or both?

13
Comments 10
1 min read
Nylas is Hiring a Developer Success Engineer

Nylas is Hiring a Developer Success Engineer

13
Comments 2
2 min read
Nylas is Hiring a Partner Engineer

Nylas is Hiring a Partner Engineer

9
Comments 1
2 min read
Nylas is Hiring a Developer Success Engineer

Nylas is Hiring a Developer Success Engineer

9
Comments
2 min read
TIL: psql with VSCode

TIL: psql with VSCode

14
Comments 1
2 min read
How I learned the most about using XML with PHP

How I learned the most about using XML with PHP

29
Comments 23
2 min read
How to execute SQL?

How to execute SQL?

15
Comments 8
3 min read
Example of complex SQL query to get as much data as possible from Database.

Example of complex SQL query to get as much data as possible from Database.

36
Comments 7
4 min read
Dirt simple SQL queries in F#

Dirt simple SQL queries in F#

30
Comments 16
5 min read
Installing SQL Server for Docker

Installing SQL Server for Docker

7
Comments
2 min read
The SQL I Love. Efficient pagination of a table with 100M records

The SQL I Love. Efficient pagination of a table with 100M records

148
Comments 10
6 min read
Random Oracle tips

Random Oracle tips

13
Comments
1 min read
Conditional SQL JOIN

Conditional SQL JOIN

6
Comments 1
2 min read
ADD_MONTHS and TRUNC for calculating dates in Oracle PL/SQL

ADD_MONTHS and TRUNC for calculating dates in Oracle PL/SQL

1
Comments
1 min read
Sqlite db for Android

Sqlite db for Android

2
Comments
1 min read
What's your experience with text IDs in SQL database?

What's your experience with text IDs in SQL database?

16
Comments 9
1 min read
Things I learnt today

Things I learnt today

21
Comments
1 min read
SQL Tutorial Library from Career Karma

SQL Tutorial Library from Career Karma

9
Comments
3 min read
A Guide to Indexes in Oracle

A Guide to Indexes in Oracle

32
Comments 1
6 min read
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
loading...