DEV Community

Jing profile picture

Jing

Data expert & tech enthusiast. Passionate about solving real-world problems with data.

Joined Joined on 

Pronouns

she

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore
jing_li profile
Jing for Chat2DB

Safeguarding Your PostgreSQL Data: A Practical Guide to pg_dump and pg_restore

#postgres #database #sql
Comments
5 min read

Want to connect with Jing?

Create an account to connect with Jing. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Mastering Foreign Keys in MySQL: A Comprehensive Guide
jing_li profile
Jing for Chat2DB

Mastering Foreign Keys in MySQL: A Comprehensive Guide

#mysql #sql #programming #database
Comments
6 min read
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)
jing_li profile
Jing for Chat2DB

Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

#programming #postgres #sql #database
3
Comments
6 min read
SQL Subqueries: Power Up Your Data Retrieval
jing_li profile
Jing for Chat2DB

SQL Subqueries: Power Up Your Data Retrieval

#mysql #database #sql #programming
Comments
7 min read
Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!
jing_li profile
Jing for Chat2DB

Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

#programming #mysql #database #sql
1
Comments
5 min read
The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?
jing_li profile
Jing for Chat2DB

The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

#mysql #database #sql #programming
Comments
5 min read
EXPLAIN It! Your Fast Track to Fixing Slow SQL
jing_li profile
Jing for Chat2DB

EXPLAIN It! Your Fast Track to Fixing Slow SQL

#mysql #sql #programming
Comments
8 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!
jing_li profile
Jing for Chat2DB

Slow SQL? Diagnose & Fix Bottlenecks Fast!

#mysql #database #sql #postgres
Comments
6 min read
SQL Optimization Techniques for Better Performance
jing_li profile
Jing for Chat2DB

SQL Optimization Techniques for Better Performance

#database #sql #programming #beginners
Comments
13 min read
Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles
jing_li profile
Jing for Chat2DB

Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles

#mysql #database #ai
Comments
5 min read
How to Connect to MySQL Using Chat2DB for Visual Database Management
jing_li profile
Jing for Chat2DB

How to Connect to MySQL Using Chat2DB for Visual Database Management

#mysql #database #datascience #ai
1
Comments
3 min read
MySQL Master-Slave Replication Delay Optimization
jing_li profile
Jing for Chat2DB

MySQL Master-Slave Replication Delay Optimization

#mysql #database #sql #programming
Comments
7 min read
SQLite Tutorial: Installation, Usage, and Best Practices
jing_li profile
Jing for Chat2DB

SQLite Tutorial: Installation, Usage, and Best Practices

#showdev #sql #database
1
Comments
8 min read
SQL Server vs PostgreSQL: From Architecture to Cost
jing_li profile
Jing for Chat2DB

SQL Server vs PostgreSQL: From Architecture to Cost

#sqlserver #postgres #database #sql
4
Comments
5 min read
How NL2SQL Tools Like Chat2DB Simplify Data
jing_li profile

How NL2SQL Tools Like Chat2DB Simplify Data

#text2sql #sql #mysql #database
Comments
11 min read
Reasons for Index Invalidity in Databases
jing_li profile

Reasons for Index Invalidity in Databases

#database #sql #text2sql #ai
Comments
4 min read
Top 5 Text2SQL Tools for Effortless SQL Generation
jing_li profile

Top 5 Text2SQL Tools for Effortless SQL Generation

#database #sql #mysql #ai
2
Comments 1
7 min read
Top AI Tools for Generating SQL in 2024
jing_li profile

Top AI Tools for Generating SQL in 2024

#database #sql #development
1
Comments 1
8 min read
SQL for Data Validation: Implementing Business Rules and Constraints
jing_li profile

SQL for Data Validation: Implementing Business Rules and Constraints

#sql #database #opensource #ai
1
Comments
5 min read
Exploring Microsoft SQL Server: Powering Enterprise Data Management
jing_li profile

Exploring Microsoft SQL Server: Powering Enterprise Data Management

#sql #opensource #ai #chatgpt
Comments
10 min read
What Is a NoSQL Database and When Should You Use It?
jing_li profile

What Is a NoSQL Database and When Should You Use It?

#database #sql #nosql #mysql
7
Comments 4
6 min read
What Are Stored Procedures?
jing_li profile

What Are Stored Procedures?

#database #sql #mysql
Comments
8 min read
Statement Timeout in PostgreSQL
jing_li profile

Statement Timeout in PostgreSQL

#programming #tutorial #database #postgres
1
Comments
4 min read
How to create a table with SQL code?
jing_li profile

How to create a table with SQL code?

#sql #database #ai #opensource
3
Comments
6 min read
Chat2DB: Data Analysis Without Writing SQL Code
jing_li profile

Chat2DB: Data Analysis Without Writing SQL Code

#sql #database #datascience #opensource
2
Comments
4 min read
Use Natural Language to Query Your Database with Chat2DB
jing_li profile

Use Natural Language to Query Your Database with Chat2DB

#sql #database #programming #ai
5
Comments 1
5 min read
Differences Between DROP, DELETE and TRUNCATE in SQL
jing_li profile

Differences Between DROP, DELETE and TRUNCATE in SQL

#programming #beginners #tutorial #ai
5
Comments
5 min read
loading...