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.
YugabyteDB table_id UUID for PostgreSQL tables

YugabyteDB table_id UUID for PostgreSQL tables

7
Comments 3
6 min read
Javascript, Sql, and File Saving

Javascript, Sql, and File Saving

6
Comments
2 min read
Using Athena Views As A Source In Glue

Using Athena Views As A Source In Glue

17
Comments 3
4 min read
3 SQL Interview Tips For Data Scientists And Data Engineers

3 SQL Interview Tips For Data Scientists And Data Engineers

13
Comments
8 min read
AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022

AzureFunBytes Reminder - Intro to @Azure Stream Analytics with @fleid_bi - 02/17/2022

8
Comments
4 min read
Exploring Git Repos With MergeStat 🔬

Exploring Git Repos With MergeStat 🔬

22
Comments 1
6 min read
Concorrência em banco de dados explicada de forma simples

Concorrência em banco de dados explicada de forma simples

11
Comments
5 min read
[mysql curtas] Função case no MySQL

[mysql curtas] Função case no MySQL

7
Comments
1 min read
Finding all tables with a specific column name (postgres)

Finding all tables with a specific column name (postgres)

6
Comments
3 min read
Database: DDL, DML, DCL, TCL

Database: DDL, DML, DCL, TCL

4
Comments
2 min read
How to generate Permutations in SQL?

How to generate Permutations in SQL?

5
Comments
2 min read
Leetcode SQL: 175. Combine Two Tables

Leetcode SQL: 175. Combine Two Tables

11
Comments
2 min read
Order of Execution in a SQL Query.

Order of Execution in a SQL Query.

7
Comments
5 min read
5 Tips On How To Become a Better Data Analyst

5 Tips On How To Become a Better Data Analyst

22
Comments
5 min read
Polymorphic joins in Active Record

Polymorphic joins in Active Record

21
Comments 4
3 min read
Deadlock in mysql

Deadlock in mysql

4
Comments
2 min read
Tools for Querying Logs with SQL

Tools for Querying Logs with SQL

5
Comments
9 min read
Crack the top 40 SQL interview questions

Crack the top 40 SQL interview questions

18
Comments 3
14 min read
Programmatic inspection of databases in Go using Atlas

Programmatic inspection of databases in Go using Atlas

7
Comments
8 min read
Protect your project from SQL injections

Protect your project from SQL injections

7
Comments 1
3 min read
Most recent record (of many items) with YugabyteDB 🚀

Most recent record (of many items) with YugabyteDB 🚀

9
Comments
11 min read
YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

YBDemo: simple 💻 demo lab for YugabyteDB with Java client and Docker🚀☕🐳🐘

4
Comments
1 min read
Supabase Date Protection on PostgreSQL

Supabase Date Protection on PostgreSQL

12
Comments
3 min read
REST Data Service on YugabyteDB / PostgreSQL with PostgREST

REST Data Service on YugabyteDB / PostgreSQL with PostgREST

12
Comments
3 min read
Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

Coding Unmanaged and Managed Transactions with NodeJS, Express and Sequelize

8
Comments
2 min read
SQL Duplicates

SQL Duplicates

6
Comments
2 min read
Links úteis para DBAs e DBREs

Links úteis para DBAs e DBREs

2
Comments
7 min read
How to Insert Thousands of Rows from an Excel / CSV File into a database with a single database call

How to Insert Thousands of Rows from an Excel / CSV File into a database with a single database call

3
Comments
2 min read
100 Days of Learning - Day 5

100 Days of Learning - Day 5

2
Comments 5
2 min read
Creating a database using PostgreSQL

Creating a database using PostgreSQL

5
Comments
3 min read
100 Days Of Learning - Day 4

100 Days Of Learning - Day 4

2
Comments
2 min read
#SQL na unha: recursos do SGBD

#SQL na unha: recursos do SGBD

6
Comments
3 min read
Parsing Data with Just SQL

Parsing Data with Just SQL

6
Comments
7 min read
How to use SQL to directly query files

How to use SQL to directly query files

5
Comments 1
7 min read
Pandas and SQL side by side

Pandas and SQL side by side

6
Comments
21 min read
How to shape sample data with PostgreSQL generate_series() and SQL

How to shape sample data with PostgreSQL generate_series() and SQL

7
Comments
21 min read
Create Streaming SQL Pipelines With dbt

Create Streaming SQL Pipelines With dbt

7
Comments
6 min read
#SQL na unha: manipulando dados

#SQL na unha: manipulando dados

7
Comments
6 min read
PostgreSQL WAL activities

PostgreSQL WAL activities

7
Comments 2
5 min read
Quill- Most efficient Scala driver for Apache Cassandra and Spark

Quill- Most efficient Scala driver for Apache Cassandra and Spark

2
Comments
4 min read
Quick start with Postgres ⚡

Quick start with Postgres ⚡

12
Comments 1
3 min read
Import a CSV file into a MySQL database using PHP PDO (fast af) 🚀

Import a CSV file into a MySQL database using PHP PDO (fast af) 🚀

5
Comments
2 min read
Database concurrency as simple as possible

Database concurrency as simple as possible

11
Comments
5 min read
#SQL na unha: definindo estrutura do banco

#SQL na unha: definindo estrutura do banco

2
Comments
4 min read
#SQL na unha: banco de dados e primeiros comandos

#SQL na unha: banco de dados e primeiros comandos

4
Comments 2
4 min read
PostgreSQL temp files usage

PostgreSQL temp files usage

17
Comments 19
5 min read
SQL Beginner Friendly Cheatsheet

SQL Beginner Friendly Cheatsheet

16
Comments
2 min read
Supabase Vs Firebase Pricing and When To Use Which

Supabase Vs Firebase Pricing and When To Use Which

21
Comments 6
3 min read
Water of Life - A Scotch Whisky API

Water of Life - A Scotch Whisky API

4
Comments 1
3 min read
5 ways to implement case-insensitive search in SQLite with full Unicode support

5 ways to implement case-insensitive search in SQLite with full Unicode support

6
Comments 1
10 min read
SQL Server Primary Keys

SQL Server Primary Keys

7
Comments 1
6 min read
End-To-End Type Safety: What, Why and How

End-To-End Type Safety: What, Why and How

7
Comments 4
15 min read
100 Languages Speedrun: Episode 63: CSVQ

100 Languages Speedrun: Episode 63: CSVQ

6
Comments
5 min read
Postgres UNNEST cheat sheet for bulk operations

Postgres UNNEST cheat sheet for bulk operations

16
Comments
3 min read
MindsDB: Creating machine learning predictive models using SQL.

MindsDB: Creating machine learning predictive models using SQL.

17
Comments 4
8 min read
Apache ShardingSphere 5.0.0 Kernel: API Adjustments

Apache ShardingSphere 5.0.0 Kernel: API Adjustments

6
Comments
6 min read
How Covid changed the way we work with SQL

How Covid changed the way we work with SQL

2
Comments
4 min read
MindsDB: Your introduction to creating machine learning predictive models.

MindsDB: Your introduction to creating machine learning predictive models.

7
Comments
8 min read
Interview Questions of the SQL

Interview Questions of the SQL

4
Comments 1
1 min read
Interview Questions of the SQL

Interview Questions of the SQL

3
Comments
1 min read
loading...