loading...

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
Use PowerShell to create a SQL Azure firewall rule for your current IP

Use PowerShell to create a SQL Azure firewall rule for your current IP

Reactions 2
3 min read
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

Reactions 41
6 min read
DDL Basic command examples

DDL Basic command examples

Reactions 7 Comments 2
1 min read
MSQL Subquery

MSQL Subquery

Reactions 2 Comments 1
1 min read
How To Integrate HoneySQL with PostgreSQL

How To Integrate HoneySQL with PostgreSQL

Reactions 2
3 min read
SQL Join vs Subquery: The Game Changer

SQL Join vs Subquery: The Game Changer

Reactions 24 Comments 2
3 min read
Create SQL from CSV files for larger updation or insertion

Create SQL from CSV files for larger updation or insertion

Reactions 4
2 min read
What is time-series data, and why are we building a time-series database (TSDB)?

What is time-series data, and why are we building a time-series database (TSDB)?

Reactions 10
7 min read
Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

Reactions 2
1 min read
Querying JSON and its nested objects with TSQL

Querying JSON and its nested objects with TSQL

Reactions 6 Comments 1
2 min read
The limits of 2 dimensions

The limits of 2 dimensions

Reactions 6 Comments 2
8 min read
varchar(n) - how big should n be?

varchar(n) - how big should n be?

Reactions 2 Comments 4
1 min read
How to Drop All Tables in PostgreSQL Database

How to Drop All Tables in PostgreSQL Database

Reactions 4
4 min read
Battling RecordNotUnique in Rails

Battling RecordNotUnique in Rails

Reactions 7
4 min read
Write complex SQL with sub query easily in Rails

Write complex SQL with sub query easily in Rails

Reactions 9 Comments 3
1 min read
Entity-attribute-value model in relational databases. Should globals be emulated on tables? Part 1.

Entity-attribute-value model in relational databases. Should globals be emulated on tables? Part 1.

Reactions 2
7 min read
Sinatra CRUD MVC Project

Sinatra CRUD MVC Project

Reactions 3
2 min read
What are SQL Joins? Types of SQL joins explained

What are SQL Joins? Types of SQL joins explained

Reactions 25
6 min read
Role based security database design

Role based security database design

Reactions 5
3 min read
4 Quick Facts About dbt Testing

4 Quick Facts About dbt Testing

Reactions 6
4 min read
[Video] How to install the latest stable MariaDB version on CentOS 8

[Video] How to install the latest stable MariaDB version on CentOS 8

Reactions 12 Comments 1
1 min read
Basics SQL - CREATE Database

Basics SQL - CREATE Database

Reactions 8
1 min read
Implement a kafka like consumer strategy to process records in your database

Implement a kafka like consumer strategy to process records in your database

Reactions 4
3 min read
SQL Vs Oracle – Which One Is Better?

SQL Vs Oracle – Which One Is Better?

Reactions 3
4 min read
Fast & reliable JSONB deep structure update in PostgreSQL

Fast & reliable JSONB deep structure update in PostgreSQL

Reactions 9
4 min read
SQL Cheat Sheet: Top 10 Most Important SQL Commands To Know

SQL Cheat Sheet: Top 10 Most Important SQL Commands To Know

Reactions 33 Comments 1
3 min read
Connect the DataBase | SQLite-Python Series

Connect the DataBase | SQLite-Python Series

Reactions 8
2 min read
Database Version Control With Liquibase

Database Version Control With Liquibase

Reactions 3
4 min read
What is "SQL Injection" and how to protect our database?

What is "SQL Injection" and how to protect our database?

Reactions 7 Comments 2
1 min read
🚀 3 Tools To Scale and Grow Your Side Projects

🚀 3 Tools To Scale and Grow Your Side Projects

Reactions 73 Comments 11
3 min read
QuestDB announces Grafana support

QuestDB announces Grafana support

Reactions 7
1 min read
Types of NoSQL Databases

Types of NoSQL Databases

Reactions 3
4 min read
What is mongo DB ? and why it is getting more popularity?

What is mongo DB ? and why it is getting more popularity?

Reactions 17 Comments 6
2 min read
Cliff - The rust DBMS

Cliff - The rust DBMS

Reactions 6 Comments 2
1 min read
The best way to synchronize (one way) a table in SQL Server

The best way to synchronize (one way) a table in SQL Server

Reactions 2
4 min read
Introduction to full-text operators and basic search

Introduction to full-text operators and basic search

Reactions 6 Comments 2
10 min read
Never Trust User Input

Never Trust User Input

Reactions 6 Comments 4
3 min read
SQL & Database Wrap Up - October 2020

SQL & Database Wrap Up - October 2020

Reactions 26 Comments 1
2 min read
How and When to Use SQL Window Functions

How and When to Use SQL Window Functions

Reactions 7
2 min read
DynamoDB or PostgreSQL???

DynamoDB or PostgreSQL???

Reactions 3 Comments 1
1 min read
MySQL or MongoDB? What to Choose for your Next Project?

MySQL or MongoDB? What to Choose for your Next Project?

Reactions 38 Comments 13
2 min read
Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

Rails 6.1 supports order DESC for find_each, find_in_batches, and in_batches

Reactions 3
1 min read
Se conectando ao PostgreSQL usando Golang

Se conectando ao PostgreSQL usando Golang

Reactions 8
11 min read
Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

Kubernetes: running SQL migrations with Kubernetes Job and Helm hook

Reactions 10
11 min read
How to Backup and Restore SQL Database from One Server to Another Server

How to Backup and Restore SQL Database from One Server to Another Server

Reactions 4
3 min read
XAMPP Installation Step By Step on MacOs

XAMPP Installation Step By Step on MacOs

Reactions 7 Comments 2
2 min read
SQL Query Inner Join for SUM Amount

SQL Query Inner Join for SUM Amount

Reactions 6 Comments 1
3 min read
DynamicODataToSQL : dotnet OData to SQL query converter

DynamicODataToSQL : dotnet OData to SQL query converter

Reactions 2
1 min read
A new TypeScript Postgres query builder

A new TypeScript Postgres query builder

Reactions 8
4 min read
Beginners guide to Integrating Python and SQL

Beginners guide to Integrating Python and SQL

Reactions 22 Comments 1
4 min read
How to Install MySQL Workbench On Windows

How to Install MySQL Workbench On Windows

Reactions 6
3 min read
Geospatial Data: A New Dimension for .NET

Geospatial Data: A New Dimension for .NET

Reactions 4
1 min read
Node.js with SQLite

Node.js with SQLite

Reactions 7 Comments 3
3 min read
Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

Simple CRUD REST API With Lumen + MySQL + Eloquent ORM

Reactions 7
8 min read
Getting Started with IntelliJ IDEA and Distributed SQL

Getting Started with IntelliJ IDEA and Distributed SQL

Reactions 5
6 min read
Two free tools to format SQL queries

Two free tools to format SQL queries

Reactions 7
3 min read
Lakers < ActiveRecord::Base

Lakers < ActiveRecord::Base

Reactions 26 Comments 8
9 min read
3 Things I wish I knew about databases two years ago

3 Things I wish I knew about databases two years ago

Reactions 5
3 min read
SQL or NoSQL?

SQL or NoSQL?

Reactions 7 Comments 6
1 min read
Some things you should know about eager loading in ActiveRecord

Some things you should know about eager loading in ActiveRecord

Reactions 12 Comments 2
9 min read
loading...