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

Building a Slack SQL "inventory" Bot

8
Comments
1 min read
Fruit Cart: Config

Fruit Cart: Config

5
Comments
4 min read
Making your relational database a little more graphy

Making your relational database a little more graphy

28
Comments
5 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

164
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

9
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 11
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

23
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
Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

5
Comments
4 min read
5 Articles worth Reading this week | Software Developers

5 Articles worth Reading this week | Software Developers

8
Comments 1
4 min read
How to test database interactions in golang applications

How to test database interactions in golang applications

23
Comments 5
2 min read
Improving PostgreSQL queries

Improving PostgreSQL queries

233
Comments 6
23 min read
SQL Workflow: Visual Studio Code + Snippets

SQL Workflow: Visual Studio Code + Snippets

10
Comments
6 min read
Enhance your PostgreSQL practice on MacOSX with Postico

Enhance your PostgreSQL practice on MacOSX with Postico

6
Comments
3 min read
Spring Data R2DBC for Microsoft SQL Server

Spring Data R2DBC for Microsoft SQL Server

7
Comments
7 min read
Writing JOINS in SQL

Writing JOINS in SQL

9
Comments 1
3 min read
SQL pronunciation

SQL pronunciation

5
Comments 6
1 min read
How to make your Database FAST with little effort!

How to make your Database FAST with little effort!

34
Comments 2
4 min read
How to get data from an MySQL database in React Native

How to get data from an MySQL database in React Native

45
Comments 55
4 min read
Ploi.io - Server Management Tool

Ploi.io - Server Management Tool

10
Comments 3
2 min read
Build a CRUD App with ASP.NET Core 2.2 and SQL Server

Build a CRUD App with ASP.NET Core 2.2 and SQL Server

14
Comments
12 min read
How I do solve this impossible SQL query?

How I do solve this impossible SQL query?

14
Comments 15
2 min read
Updating a Table with the Values of a Different One

Updating a Table with the Values of a Different One

5
Comments 1
2 min read
MySQL High Availability Framework Explained – Part III: Failover Scenarios

MySQL High Availability Framework Explained – Part III: Failover Scenarios

11
Comments
5 min read
Pitfalls of the MINUS-comparison

Pitfalls of the MINUS-comparison

6
Comments
3 min read
Non-profit projects: how to work with little to no finance?

Non-profit projects: how to work with little to no finance?

6
Comments 4
1 min read
SQL vs Elastic Search for storing CRM Data

SQL vs Elastic Search for storing CRM Data

5
Comments 3
1 min read
DBMS For Application Development: Relational Model & Relational Database

DBMS For Application Development: Relational Model & Relational Database

9
Comments
2 min read
SQL: Copy Tables and Massive Update

SQL: Copy Tables and Massive Update

8
Comments 2
2 min read
Differences Between SQL And NoSQL Databases

Differences Between SQL And NoSQL Databases

90
Comments 2
4 min read
How to debug SQL Databases

How to debug SQL Databases

5
Comments
3 min read
How to write this SQL select the best way?

How to write this SQL select the best way?

10
Comments 7
1 min read
How To Merge Multiple SQL Tables Into One MongoDB Collection

How To Merge Multiple SQL Tables Into One MongoDB Collection

7
Comments
9 min read
2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

8
Comments
11 min read
Determining the worth of one-off Reporting.

Determining the worth of one-off Reporting.

13
Comments 3
4 min read
How to organize SQL legacy Databases

How to organize SQL legacy Databases

6
Comments
4 min read
That’s not very Data Warehouse - an argument against elegant SQL code

That’s not very Data Warehouse - an argument against elegant SQL code

24
Comments 5
4 min read
SQL: Como adicionar uma quebra de linha em uma query

SQL: Como adicionar uma quebra de linha em uma query

7
Comments
1 min read
How to versioning SQL databases architecture using GitHub and Visual Studio

How to versioning SQL databases architecture using GitHub and Visual Studio

2
Comments 2
4 min read
How to Generate Contents of a New CSV Column Using JavaScript

How to Generate Contents of a New CSV Column Using JavaScript

6
Comments
2 min read
What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

60
Comments 1
14 min read
7 reasons why learning SQL is still important for Rails developers

7 reasons why learning SQL is still important for Rails developers

18
Comments 1
5 min read
loading...