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

13
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

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

11
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
Building a Slack SQL "inventory" Bot

Building a Slack SQL "inventory" Bot

8
Comments
1 min read
Making your relational database a little more graphy

Making your relational database a little more graphy

29
Comments
5 min read
Fruit Cart: Config

Fruit Cart: Config

5
Comments
4 min read
Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

165
Comments 5
10 min read
Suggestion Needed | Flask or Django ?

Suggestion Needed | Flask or Django ?

7
Comments 7
1 min read
Handling transactions and concurrency in MikroORM

Handling transactions and concurrency in MikroORM

11
Comments
7 min read
Understanding Rails Eager-Loading

Understanding Rails Eager-Loading

59
Comments
6 min read
SimQLe - very simple SQL in Python

SimQLe - very simple SQL in Python

10
Comments
2 min read
Getting Started with PostgreSQL

Getting Started with PostgreSQL

61
Comments
5 min read
Advanced counter_cache in Rails with SQL triggers

Advanced counter_cache in Rails with SQL triggers

12
Comments
4 min read
4 MySQL traps

4 MySQL traps

52
Comments 2
3 min read
Connect to Amazon Athena with a SQL client

Connect to Amazon Athena with a SQL client

10
Comments 1
2 min read
Flask Recipe - RESTful CRUD using sqlalchemy

Flask Recipe - RESTful CRUD using sqlalchemy

14
Comments 1
5 min read
Testing Your Database Migrations With Flyway and Testcontainers

Testing Your Database Migrations With Flyway and Testcontainers

26
Comments
5 min read
Testing the Deathstar security with utPLSQL contexts

Testing the Deathstar security with utPLSQL contexts

7
Comments
4 min read
How To Select a Relational Database Management System

How To Select a Relational Database Management System

14
Comments
5 min read
Entity Relationship Diagrams explained by Sonic the Hedgehog

Entity Relationship Diagrams explained by Sonic the Hedgehog

228
Comments 12
2 min read
How Functions and Composite Types Changed the Way I Use PostgreSQL

How Functions and Composite Types Changed the Way I Use PostgreSQL

12
Comments 1
6 min read
SQL- Overview and Types of commands

SQL- Overview and Types of commands

13
Comments
3 min read
How I Made PostGraphile Faster Than Prisma: 1 Year Later

How I Made PostGraphile Faster Than Prisma: 1 Year Later

28
Comments
8 min read
Have you ever forgotten your SQL server instance name?

Have you ever forgotten your SQL server instance name?

5
Comments
1 min read
Today I learned: Why there aren't many tools for SQLing a csv

Today I learned: Why there aren't many tools for SQLing a csv

6
Comments 2
1 min read
Creating a Simple Contacts List with Go and PostgreSQL

Creating a Simple Contacts List with Go and PostgreSQL

100
Comments
10 min read
The Curious Case of nvarchar and varchar in Entity Framework

The Curious Case of nvarchar and varchar in Entity Framework

24
Comments 4
6 min read
Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

8
Comments 1
3 min read
Browser indexeddb operation using jsstore

Browser indexeddb operation using jsstore

11
Comments
5 min read
loading...