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

103
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

15
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

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

Scraping the NBA p1- Players/Teams

8
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

12
Comments
1 min read
Managing Relationships in SQLAlchemy Data Models

Managing Relationships in SQLAlchemy Data Models

12
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

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