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.
[ Database ] - Session Object of SQLAlchemy

[ Database ] - Session Object of SQLAlchemy

5
Comments
1 min read
Top 10 Manual Testing Interview Questions

Top 10 Manual Testing Interview Questions

4
Comments
2 min read
Using an Array of strings in a query with Oracle PL/SQL

Using an Array of strings in a query with Oracle PL/SQL

11
Comments
1 min read
Coding a database and UI that allows students to share books on a website.

Coding a database and UI that allows students to share books on a website.

4
Comments
1 min read
SQL-Quick tip #5 - Create a sequence of date and time

SQL-Quick tip #5 - Create a sequence of date and time

25
Comments
1 min read
Usando transaction no knex

Usando transaction no knex

6
Comments
1 min read
SQL-Quick tip #2 - Randomize rows

SQL-Quick tip #2 - Randomize rows

5
Comments
1 min read
Stalactite ORM 1.0.0 is out !

Stalactite ORM 1.0.0 is out !

7
Comments
1 min read
SQL-Quick tip #3 - Prepending zeroes

SQL-Quick tip #3 - Prepending zeroes

6
Comments
1 min read
Criação de um Micro ORM

Criação de um Micro ORM

2
Comments
2 min read
Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

Efficient pagination in YugabyteDB & PostgreSQL 📃🐘🚀

6
Comments
10 min read
A way to translate sql scripts to a different dialect

A way to translate sql scripts to a different dialect

2
Comments
1 min read
Query S3 with SQL using S3 Select

Query S3 with SQL using S3 Select

11
Comments
5 min read
How to generate time-series data in QuestDB

How to generate time-series data in QuestDB

9
Comments 1
9 min read
Combining dbt Metrics with API, Caching, and Access Control

Combining dbt Metrics with API, Caching, and Access Control

17
Comments
9 min read
10 AWS Services that use SQL

10 AWS Services that use SQL

6
Comments
11 min read
SQL undercover

SQL undercover

2
Comments
2 min read
Logical Grouping in Laravel Query Builder

Logical Grouping in Laravel Query Builder

6
Comments
2 min read
Postgres variables & clean up

Postgres variables & clean up

3
Comments
1 min read
16 Data Analytics Buzzwords You Need To Know

16 Data Analytics Buzzwords You Need To Know

19
Comments
2 min read
SQL-Quick tip #4 - Random Int for each row

SQL-Quick tip #4 - Random Int for each row

15
Comments
1 min read
Saving the UNION with HoneySQL

Saving the UNION with HoneySQL

7
Comments 1
5 min read
Ensuring Conversion of a Float to Nvarchar in T-SQL

Ensuring Conversion of a Float to Nvarchar in T-SQL

5
Comments
2 min read
PHP e SQL Benchmark: Múltiplos joins VS várias queries menores

PHP e SQL Benchmark: Múltiplos joins VS várias queries menores

6
Comments
5 min read
Handling Dynamic Objects in CrateDB

Handling Dynamic Objects in CrateDB

3
Comments
7 min read
loading...