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.
SQLite dot commands: Output mode separator command
mr_destructive profile

SQLite dot commands: Output mode separator command

#sql #sqlite #database #programming
2
Comments
2 min read
The main tasks of a Database Administrator (DBA) by 2025
leandro_nnz profile

The main tasks of a Database Administrator (DBA) by 2025

#database #dba #sql
5
Comments
27 min read
SQLite dot commands: Output mode
mr_destructive profile

SQLite dot commands: Output mode

#sql #sqlite #database #programming
2
Comments
9 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide
mehul_budasana profile

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

#googlecloud #gcp #sql #database
6
Comments
5 min read
Associações polimórficas no Rails: como fazer, prós e contras
pedroleo profile

Associações polimórficas no Rails: como fazer, prós e contras

#ruby #rails #sql #development
17
Comments 3
4 min read
Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)
pavelgrigoryev profile

Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

#datascience #beginners #sql #python
5
Comments
2 min read
Building SW: Lessons from the Backend
ryansgi profile

Building SW: Lessons from the Backend

#go #opensource #webdev #sql
4
Comments
8 min read
Automating Old Partition Cleanup in Oracle with PL/SQL
mrcaption49 profile

Automating Old Partition Cleanup in Oracle with PL/SQL

#automation #database #sql
6
Comments
3 min read
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search
mindsdbteam profile

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

#ai #sql #knowledgebase #tutorial
Comments
12 min read
Handle Large PostgreSQL Schemas with a GUI Tool
roxana_haidiner profile

Handle Large PostgreSQL Schemas with a GUI Tool

#postgres #postgressql #database #sql
6
Comments
3 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations
franckpachot profile

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

#mongodb #postgres #sql #json
Comments
8 min read
Filtering and Retrieving in SQL
koustav profile

Filtering and Retrieving in SQL

#sql #mysql #database #tutorial
1
Comments 2
3 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
rebooter_s profile

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

#sql #mysql #performance #ai
1
Comments 1
14 min read
Oracle SQL Plan Management - 23ai features backported to 19.22
abhilash8 profile

Oracle SQL Plan Management - 23ai features backported to 19.22

#sql #oracle #tuning #oci
Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips
dbvismarketing profile

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql
Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.