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

146
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
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
Speeding up unique constraint checks in Postgres... or not

Speeding up unique constraint checks in Postgres... or not

6
Comments
3 min read
Aerospike JDBC driver: SQL DDL compliance

Aerospike JDBC driver: SQL DDL compliance

6
Comments 3
1 min read
Finding Meow 😺 — the cutest cat from each town using Elasticsearch

Finding Meow 😺 — the cutest cat from each town using Elasticsearch

4
Comments
6 min read
Introduction to the Aerospike JDBC driver

Introduction to the Aerospike JDBC driver

6
Comments
2 min read
AI + Github API = Issue Sentiment Classification

AI + Github API = Issue Sentiment Classification

3
Comments
3 min read
How do you handle database migrations ?

How do you handle database migrations ?

2
Comments
1 min read
Tutorial: Building a Slack Bot that Writes Custom Queries against your Database

Tutorial: Building a Slack Bot that Writes Custom Queries against your Database

6
Comments
3 min read
Find the SQL Server service account with sys.dm_server_services

Find the SQL Server service account with sys.dm_server_services

4
Comments
2 min read
Tutorial: Create a Dashboard of SQL Datasets

Tutorial: Create a Dashboard of SQL Datasets

7
Comments
3 min read
How to Convert date format to PHP with MYSQLI, using secure queries to avoid SQL injection

How to Convert date format to PHP with MYSQLI, using secure queries to avoid SQL injection

1
Comments
1 min read
Quick Check of SQL Table Contents With Data Visualizers

Quick Check of SQL Table Contents With Data Visualizers

2
Comments
3 min read
Making non-SARGable queries seek, without changing the query

Making non-SARGable queries seek, without changing the query

5
Comments
3 min read
What is SQL injection and how do I avoid it in Go?

What is SQL injection and how do I avoid it in Go?

15
Comments 7
5 min read
Stop trying to shrink tempdb files

Stop trying to shrink tempdb files

5
Comments
4 min read
How to Automate Continuous Database Backup and Restore

How to Automate Continuous Database Backup and Restore

5
Comments
3 min read
Working on a hair professional mobile app (Xamarin, C#, PHP, MySQL)

Working on a hair professional mobile app (Xamarin, C#, PHP, MySQL)

6
Comments
2 min read
Recompile dependent PL/SQL code after changes

Recompile dependent PL/SQL code after changes

5
Comments
2 min read
What is CRUD and how does it help me with my application?

What is CRUD and how does it help me with my application?

5
Comments
7 min read
X-Ray for Your Database

X-Ray for Your Database

7
Comments
8 min read
Tutorial: Schedule SQL Queries on your Database

Tutorial: Schedule SQL Queries on your Database

6
Comments 3
2 min read
The most complete bad word dataset on the internet, and using it in my Python application

The most complete bad word dataset on the internet, and using it in my Python application

20
Comments
1 min read
Supernova introduction

Supernova introduction

4
Comments
2 min read
Working with SQL Relations in Go - Part 5

Working with SQL Relations in Go - Part 5

4
Comments
5 min read
Tutorial: Automate Daily SQL Queries in 4 minutes

Tutorial: Automate Daily SQL Queries in 4 minutes

9
Comments
3 min read
Tutorial: Creating Slack Bots to Track Product Inventory

Tutorial: Creating Slack Bots to Track Product Inventory

6
Comments
3 min read
loading...