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.
SQLcl, a nicer SQL*PLUS alternative

SQLcl, a nicer SQL*PLUS alternative

9
Comments
6 min read
Choosing a Database: SQL or NoSQL? - Building a Blog

Choosing a Database: SQL or NoSQL? - Building a Blog

3
Comments
3 min read
What is Neo4j?

What is Neo4j?

15
Comments
4 min read
Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1

Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1

10
Comments
4 min read
All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!

All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!

3
Comments
14 min read
SQL vs NoSQL: Explained with Examples

SQL vs NoSQL: Explained with Examples

3
Comments
1 min read
mvn Liquibase:updateSql DatabaseException

mvn Liquibase:updateSql DatabaseException

15
Comments 4
3 min read
Build RESTful APIs Using ASP.NET Core and Entity Framework Core

Build RESTful APIs Using ASP.NET Core and Entity Framework Core

3
Comments
1 min read
Tutorial: Setting up HarperDB Cloud

Tutorial: Setting up HarperDB Cloud

19
Comments
2 min read
Databases for Windows Desktop Development: Welcome to the Jungle

Databases for Windows Desktop Development: Welcome to the Jungle

4
Comments
6 min read
Is there such thing as a truly free cloud database?

Is there such thing as a truly free cloud database?

37
Comments 31
1 min read
What they don’t tell you about being an analyst

What they don’t tell you about being an analyst

29
Comments 2
13 min read
Flyway & Azure DevOps : Rodando Flyway Localmente

Flyway & Azure DevOps : Rodando Flyway Localmente

1
Comments 2
2 min read
Flyway & Azure DevOps : Azure SQL Database

Flyway & Azure DevOps : Azure SQL Database

6
Comments 1
3 min read
Flyway & Azure DevOps : IaC com ARM Template

Flyway & Azure DevOps : IaC com ARM Template

3
Comments
4 min read
Python Basics on Hackerrank

Python Basics on Hackerrank

3
Comments
1 min read
Flyway & Azure DevOps : Conhecendo o Flyway

Flyway & Azure DevOps : Conhecendo o Flyway

6
Comments
6 min read
How To Write Better SQL: Advanced SQL Episode 1

How To Write Better SQL: Advanced SQL Episode 1

63
Comments 1
5 min read
Comparing SQL and NoSQL Databases

Comparing SQL and NoSQL Databases

6
Comments
5 min read
sending SQL results periodically to slack

sending SQL results periodically to slack

5
Comments
2 min read
Using Postgres FOR loop to generate data

Using Postgres FOR loop to generate data

16
Comments 1
2 min read
Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

78
Comments 26
5 min read
What Is Data Virtualization And Why Use It?

What Is Data Virtualization And Why Use It?

31
Comments 4
7 min read
How to run a long lasting query without interruption?

How to run a long lasting query without interruption?

4
Comments 5
1 min read
Escape SQL LIKE wildcard characters

Escape SQL LIKE wildcard characters

5
Comments
1 min read
My first endeavor with Django...

My first endeavor with Django...

4
Comments
1 min read
How to build jdbc url to Google SQL instance?

How to build jdbc url to Google SQL instance?

8
Comments
1 min read
What Happens When you Put Your SQL Database on the Internet

What Happens When you Put Your SQL Database on the Internet

2
Comments 1
7 min read
Performance and N+1 Queries: Explained, Spotted, and Solved

Performance and N+1 Queries: Explained, Spotted, and Solved

22
Comments
5 min read
When to decide for NoSQL or SQL?

When to decide for NoSQL or SQL?

6
Comments
6 min read
Automating Data Extractions From Google Sheets With Python

Automating Data Extractions From Google Sheets With Python

59
Comments 4
7 min read
How to: Scrape Facebook Groups for Apartment Rentals

How to: Scrape Facebook Groups for Apartment Rentals

15
Comments 1
3 min read
Rails Migration

Rails Migration

7
Comments
11 min read
Forward and Inverted Indexes - Requirement based differences

Forward and Inverted Indexes - Requirement based differences

10
Comments 1
4 min read
PostgreSQL: Rename database

PostgreSQL: Rename database

5
Comments 2
2 min read
Versioning a Relational Data Model

Versioning a Relational Data Model

7
Comments 2
3 min read
Transaction savepoints in Spring JDBC

Transaction savepoints in Spring JDBC

8
Comments
6 min read
Dead rows in a materialized view

Dead rows in a materialized view

23
Comments
4 min read
Is SQL enough for a career?

Is SQL enough for a career?

2
Comments 8
1 min read
Node JS: How to access MySQL remotely using SSH.

Node JS: How to access MySQL remotely using SSH.

13
Comments 1
2 min read
Relational vs NoSQL databases

Relational vs NoSQL databases

24
Comments 9
1 min read
Add new columns to table in PostgreSQL

Add new columns to table in PostgreSQL

10
Comments
1 min read
Database performance: If you're not first, you're last!

Database performance: If you're not first, you're last!

16
Comments
24 min read
Connecting Pandas to a Database with SQLAlchemy

Connecting Pandas to a Database with SQLAlchemy

13
Comments
8 min read
SQL Basics - Manage Your Data

SQL Basics - Manage Your Data

5
Comments 1
2 min read
Super Graph - turn GraphQL queries into a single SQL query

Super Graph - turn GraphQL queries into a single SQL query

16
Comments
2 min read
Postgres Table Partitioning

Postgres Table Partitioning

7
Comments
4 min read
AlaSQL in Action: The JavaScript SQL Database

AlaSQL in Action: The JavaScript SQL Database

71
Comments
3 min read
The SQL databases vs NoSQL databases [Difference]

The SQL databases vs NoSQL databases [Difference]

2
Comments
1 min read
Install LEMP Stack (Linux, Nginx, MySQL, PHP) on Ubuntu 18.04 AWS EC2 Instance

Install LEMP Stack (Linux, Nginx, MySQL, PHP) on Ubuntu 18.04 AWS EC2 Instance

7
Comments
1 min read
MySQL Bulk Insert taking long time

MySQL Bulk Insert taking long time

3
Comments
2 min read
I'm in a book! Ha!

I'm in a book! Ha!

5
Comments
1 min read
Unit Test em Stored Procedures (Sql Server) Parte I

Unit Test em Stored Procedures (Sql Server) Parte I

4
Comments
4 min read
Sql Joins

Sql Joins

9
Comments 2
1 min read
Laravel SQL Debugging

Laravel SQL Debugging

11
Comments
1 min read
Day 3: #100DaysofCode - Oh No, SQL

Day 3: #100DaysofCode - Oh No, SQL

6
Comments
3 min read
SQL Queries to Complex JSON Objects

SQL Queries to Complex JSON Objects

33
Comments 1
6 min read
Defensive SQL Query Writing

Defensive SQL Query Writing

3
Comments 2
2 min read
Working with SQLite in Python

Working with SQLite in Python

16
Comments
3 min read
Seed your SqlServer, PostgreSql and MySql databases with CSV files using yuniql migrations

Seed your SqlServer, PostgreSql and MySql databases with CSV files using yuniql migrations

10
Comments
5 min read
loading...