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