Best of SQL — February 2024
- 1
- 2
Community Picks·2y
Improve your SQL skills X2 in 5 minutes
Learn how to advance your SQL skills by working with CTEs and window functions. Discover the importance of SQL for managers and how it can help answer business questions and assist with technical designs. Explore the different types of window functions available in SQL.
- 3
- 4
How to Optimize Slow SQL Queries
Learn how to identify and optimize slow SQL queries, including methods such as using parameterized queries, configuring the database for optimal performance, and properly indexing columns. Continuous feedback tools and monitoring can help in finding and optimizing these queries.
- 5
Towards Dev·2y
3 Essential SQL Tricks You Absolutely Need to Know
Learn three essential SQL tricks that can improve efficiency and analytical capabilities. Topics include using Common Table Expressions (CTEs), creating Partial Indexes for faster searches, and implementing Conditional Aggregation in SQL queries.
- 6
InfoWorld·2y
Why developers should put the database first
Developers are being advised to prioritize the database in their application development journey. Data is considered the most important element of computing and should be the first choice in the technology stack. Various options, such as SQLite, NoSQL databases, and Neurelo, can help developers put the database first.
- 7
- 8
EverSQL·2y
SQL Optimization: a comprehensive developer’s guide
This post provides a comprehensive guide on optimizing SQL queries. It covers topics such as optimizing SELECT, INSERT, and DELETE SQL queries and provides tips on using indexes, improving joins, filtering, and more. The post also introduces EverSQL by Aiven, a tool that can provide performance insights and SQL optimization suggestions.
- 9
SQL Shack·2y
Finding Duplicates in SQL
This post explains the different ways to find duplicate values in SQL using DISTINCT and COUNT, GROUP BY and COUNT, and ROW_NUMBER functions. It provides examples and guidance on how to use these functions to identify duplicates in single columns or across multiple columns. The post also highlights the importance of managing duplicates in data storage and processing.
- 10
- 11
- 12
Pointer·2y
gptscript-ai/gptscript: Develop LLM Apps in Natural Language
GPTScript is a scripting language that allows developers to automate their interactions with OpenAI's Large Language Model (LLM). It offers a natural language programming experience and supports mixing natural language prompts with traditional scripts. GPTScript can be used for various tasks like planning a vacation, editing files, running SQL queries, and building applications.
- 13
- 14
Appwrite·2y
Understanding data queries in database management
Developers need to understand different types of data queries and their functions, such as retrieval queries, insertion queries, update queries, and deletion queries. Best practices include optimizing performance, ensuring security, maintaining data integrity, and testing queries before applying them to the production database.
- 15
Planet Python·2y
Python SQL Database Connection Guide
Learn how to connect Python with an SQL database and perform various operations. This tutorial covers installing the database library, establishing a connection, executing queries, fetching results, committing changes, and closing the connection. It also provides examples of common database operations such as creating a database, creating tables, inserting data, selecting data, updating data, joining tables, using aggregate functions, deleting tables, and deleting databases.
- 16
- 17
DEV·2y
🏁🐘Winning Race Conditions With PostgreSQL
This post discusses race conditions in databases, particularly in PostgreSQL, and provides solutions for avoiding them. It covers cases of simple uniqueness, compound uniqueness, compound multiple uniqueness, and compound referential uniqueness. The article also mentions the use of transactions, advisory locks, and the SERIALIZABLE transaction isolation level. Overall, it offers techniques to handle and prevent race conditions in database operations.
