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

42
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

150
Comments 11
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
Things I learnt today

Things I learnt today

21
Comments
1 min read
A Guide to Indexes in Oracle

A Guide to Indexes in Oracle

32
Comments 1
6 min read
SQL Tutorial Library from Career Karma

SQL Tutorial Library from Career Karma

9
Comments
3 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
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
loading...