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

46
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
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

7
Comments
2 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
Managing High Availability in PostgreSQL – Part II

Managing High Availability in PostgreSQL – Part II

11
Comments
11 min read
Build a Secure Node.js App with SQL Server

Build a Secure Node.js App with SQL Server

38
Comments 1
23 min read
Database Management Systems For Application Development: Introduction

Database Management Systems For Application Development: Introduction

10
Comments
2 min read
Simple Tips for PostgreSQL Query Optimization

Simple Tips for PostgreSQL Query Optimization

20
Comments
5 min read
#100CodeExamples – Constants in PL/SQL and SQL

#100CodeExamples – Constants in PL/SQL and SQL

8
Comments
3 min read
How much difference does adding an index to a database table make?

How much difference does adding an index to a database table make?

11
Comments
3 min read
How to Automate Dumping for SQL Databases

How to Automate Dumping for SQL Databases

13
Comments 7
3 min read
Documenting the DB: Data dictionaries

Documenting the DB: Data dictionaries

35
Comments
3 min read
Prevent SQL Injections

Prevent SQL Injections

17
Comments 4
5 min read
Often your solution is one (more) google search away

Often your solution is one (more) google search away

14
Comments
2 min read
Welcome to SQL 2: Working With Data Values

Welcome to SQL 2: Working With Data Values

12
Comments
7 min read
Welcome to SQL: Modifying Databases and Tables

Welcome to SQL: Modifying Databases and Tables

6
Comments
10 min read
SQL concepts from A to Z

SQL concepts from A to Z

865
Comments 20
14 min read
#100CodeExamples – Only one active protocol

#100CodeExamples – Only one active protocol

6
Comments
2 min read
Best Tutorial For Java & SQL?

Best Tutorial For Java & SQL?

8
Comments 12
1 min read
Breaking Postgres with Too Many Tables

Breaking Postgres with Too Many Tables

50
Comments 5
3 min read
Is SQL Really A Game Changer For Data Science Careers?

Is SQL Really A Game Changer For Data Science Careers?

24
Comments 1
4 min read
How to simplest Turing Machine works on postgreSQL

How to simplest Turing Machine works on postgreSQL

7
Comments
5 min read
Connect Flask to a Database with Flask-SQLAlchemy

Connect Flask to a Database with Flask-SQLAlchemy

26
Comments 1
9 min read
Database models and ERDs for Newbs Part: 5

Database models and ERDs for Newbs Part: 5

5
Comments
3 min read
Database models and ERDs for Newbs Part: 4

Database models and ERDs for Newbs Part: 4

9
Comments
3 min read
AlaSQL: A Real Database for Web Browsers (and Node.js)

AlaSQL: A Real Database for Web Browsers (and Node.js)

71
Comments 9
5 min read
Power of ActiveRecord and when to stop using it

Power of ActiveRecord and when to stop using it

16
Comments 2
3 min read
Database models and ERDs for Newbs Part: 3

Database models and ERDs for Newbs Part: 3

4
Comments
2 min read
loading...