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.
Enabling TLS Just got a Little Bit Easier

Enabling TLS Just got a Little Bit Easier

8
Comments 1
3 min read
Sequelize Basics for Beginners

Sequelize Basics for Beginners

27
Comments 2
6 min read
Database Domain Driven Design

Database Domain Driven Design

22
Comments
5 min read
An Introduction to Spring Boot: MySQL, JPA and Hibernate.

An Introduction to Spring Boot: MySQL, JPA and Hibernate.

28
Comments
14 min read
cool SQL article

cool SQL article

6
Comments
1 min read
Using Postgres Enum Type in Rails

Using Postgres Enum Type in Rails

41
Comments 5
3 min read
Localizing Dates In Sql Server

Localizing Dates In Sql Server

8
Comments
2 min read
Simple Laravel DB backups for MySQL/MariaDB

Simple Laravel DB backups for MySQL/MariaDB

8
Comments
3 min read
Basic Go HTTP server with Postgres

Basic Go HTTP server with Postgres

18
Comments 2
4 min read
A mini-guide — Build a REST API as a Go microservice together with MySQL

A mini-guide — Build a REST API as a Go microservice together with MySQL

201
Comments 4
4 min read
Adding missing indexes in your Rails App

Adding missing indexes in your Rails App

15
Comments
1 min read
4 Ways to Calculate a Running Total With SQL

4 Ways to Calculate a Running Total With SQL

50
Comments 7
4 min read
ArangoDB Tutorial - Getting Started with ArangoDB

ArangoDB Tutorial - Getting Started with ArangoDB

6
Comments
1 min read
Learn SQL from Scratch - PostgreSQL Tutorial for Beginners

Learn SQL from Scratch - PostgreSQL Tutorial for Beginners

37
Comments
2 min read
Understanding Databases (Relational)

Understanding Databases (Relational)

16
Comments
3 min read
Automating File Loading Into SQL Server With Python And SQL

Automating File Loading Into SQL Server With Python And SQL

18
Comments
2 min read
Postgres: Optimization & Beyond

Postgres: Optimization & Beyond

12
Comments
4 min read
Time Series Visualization using SQL Window Functions

Time Series Visualization using SQL Window Functions

28
Comments
11 min read
Using Tableau for Live Dashboards on Event Data

Using Tableau for Live Dashboards on Event Data

7
Comments
4 min read
Comparing SQL Views and Stored Procedures

Comparing SQL Views and Stored Procedures

61
Comments 5
3 min read
How we use RocksDB at Rockset

How we use RocksDB at Rockset

10
Comments
7 min read
Our Favorite Machine Learning Courses On Coursera For Free

Our Favorite Machine Learning Courses On Coursera For Free

42
Comments
10 min read
PL/SQL Object Types: putting the Structure into the Force Powers Table

PL/SQL Object Types: putting the Structure into the Force Powers Table

6
Comments
5 min read
Things I wish I knew before I got started with CosmosDB

Things I wish I knew before I got started with CosmosDB

17
Comments 4
4 min read
Building a Live Dashboard on Streaming Data Using Amazon Kinesis and Rockset

Building a Live Dashboard on Streaming Data Using Amazon Kinesis and Rockset

6
Comments
4 min read
Converged Indexing: The Secret Sauce Behind Rockset's Fast Queries

Converged Indexing: The Secret Sauce Behind Rockset's Fast Queries

3
Comments
4 min read
ON the evolution of Data Engineering

ON the evolution of Data Engineering

15
Comments
4 min read
Structure Force Powers with PL/SQL Object Types

Structure Force Powers with PL/SQL Object Types

7
Comments
6 min read
Get Started With Core SQL and Node.js for Azure Cosmos DB (Video)

Get Started With Core SQL and Node.js for Azure Cosmos DB (Video)

14
Comments
2 min read
ActiveOrient: Joins and Links

ActiveOrient: Joins and Links

6
Comments
3 min read
Descobrindo a versão do backup de SQL Server

Descobrindo a versão do backup de SQL Server

3
Comments
1 min read
The WordPress Codex: An Invaluable Resource for Better Coding

The WordPress Codex: An Invaluable Resource for Better Coding

9
Comments 1
8 min read
things you should know before a dev interview (part 1 of n)

things you should know before a dev interview (part 1 of n)

9
Comments 1
2 min read
Replicating PostgresSQL into MemSQL's columnstore

Replicating PostgresSQL into MemSQL's columnstore

15
Comments 2
8 min read
I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

102
Comments 15
4 min read
How to run SQL Server in a Docker container

How to run SQL Server in a Docker container

13
Comments
5 min read
Dataclips Power Insights at Heroku

Dataclips Power Insights at Heroku

7
Comments
5 min read
How to write unit tests for your SQL queries

How to write unit tests for your SQL queries

12
Comments
4 min read
What kind of apps have you implemented using a noSQL database like MongoDB or CouchDB?

What kind of apps have you implemented using a noSQL database like MongoDB or CouchDB?

8
Comments 3
1 min read
Making HPFanfiction Recommender

Making HPFanfiction Recommender

7
Comments
6 min read
Scraping the NBA p1- Players/Teams

Scraping the NBA p1- Players/Teams

7
Comments 1
3 min read
Sql Server Multi Column Index Improvements

Sql Server Multi Column Index Improvements

9
Comments
2 min read
How to write optional filters in SQL

How to write optional filters in SQL

10
Comments
1 min read
Managing Relationships in SQLAlchemy Data Models

Managing Relationships in SQLAlchemy Data Models

11
Comments
9 min read
Define Relationships Between SQLAlchemy Data Models

Define Relationships Between SQLAlchemy Data Models

2
Comments
12 min read
SQL Tricks: Querying The Same Table Twice

SQL Tricks: Querying The Same Table Twice

10
Comments
2 min read
The bug which worth 2k$

The bug which worth 2k$

4
Comments
1 min read
Storing and Using DateTimeOffsets in Lucee

Storing and Using DateTimeOffsets in Lucee

6
Comments
3 min read
Using SQL Server in Docker containers for basic tasks

Using SQL Server in Docker containers for basic tasks

14
Comments
4 min read
How to update objects inside JSONB arrays with PostgreSQL

How to update objects inside JSONB arrays with PostgreSQL

7
Comments
3 min read
How to implement pagination with Oracle DB in a readability way

How to implement pagination with Oracle DB in a readability way

7
Comments 1
1 min read
Are you vulnerable to a SQL injection attack? Exploiting with Sqlmap

Are you vulnerable to a SQL injection attack? Exploiting with Sqlmap

34
Comments
4 min read
Understanding SQL Injection and Prevention using Parameter Binding in PHP

Understanding SQL Injection and Prevention using Parameter Binding in PHP

32
Comments 3
1 min read
Easy email dashboards with dashflow.io

Easy email dashboards with dashflow.io

6
Comments
3 min read
Consider SQL when writing your next processing pipeline

Consider SQL when writing your next processing pipeline

43
Comments 10
6 min read
SQL GROUP BY using JavaScript

SQL GROUP BY using JavaScript

20
Comments 4
6 min read
Improving SQL Query by Adding conditions in Joins

Improving SQL Query by Adding conditions in Joins

34
Comments 11
1 min read
Weeknotes - 04 Makers

Weeknotes - 04 Makers

7
Comments 1
2 min read
More Pitfalls of the MINUS comparison

More Pitfalls of the MINUS comparison

7
Comments
3 min read
Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

21
Comments
1 min read
loading...