#sql

#sql

We're excited to launch the second edition of our User Experience Survey for DataGrip and the Database Tools & SQL Plugin! Your feedback from the previous survey helped us better understand your needs and prioritize the features and improvements that matter most to you.

To perform a 'like' search that only matches the beginning of each word, use the REGEXP pattern with a word boundary to ensure accurate results.

You may have heard about DuckDB's impressive robustness and performance. Perhaps you want to try it out - BUT WAIT, you're a data scientist and are used to pandas and/or Polars, not SQL.

Prisma operates at a high level of abstraction, simplifying data fetching and manipulation with an easy-to-understand API, but with less control over SQL.

The cheat sheet provides an extensive reference for business analysts, showcasing various ways to join two tables across SQL, Spark, and Python pandas. It emphasizes the completeness of the guide, asserting that it includes less common operations such as cross joins, making it unique among similar resources. The aesthetic appeal of the sheet is also highlighted, aiming to engage users visually and practically.

NULL in SQL is a critical concept representing missing or unknown values, requiring careful handling to maintain data integrity in queries.

"The migration tool should maintain every migration in a single SQL file, containing both 'up' and 'down' parts, enhancing flexibility and rollback capabilities."

We don't need to live with SQL's flaws. The language is fixable! This paper shows how pipe-structured data flow, inspired by other languages and APIs, can be added to SQL with moderate effort. The resulting language is still SQL, but it's a better SQL. It's more flexible, more extensible, and easier to use.

Java Database Connectivity (JDBC) drivers serve as essential middleware between Java applications and databases, facilitating SQL query execution and data retrieval.

"Historically, the most common way of defining primary keys in PostgreSQL was with the serial type, but now the official documentation advises against them in favor of identity columns."

With virtual generated columns, we avoid using additional disk storage. Instead, the database calculates their value on demand, for example, during a query. However, PostgreSQL currently lacks support for the virtual generated columns.

This month's Patch Tuesday from Microsoft was complex, with no zero-day vulnerabilities reported, but a significant number of updates, particularly affecting SQL, OLE, and ODBC components, underlining the need for thorough evaluation.

COUNT DISTINCT refers to an aggregate function that points to the unique, repeated values in one single column of a data table. Unlike the regular type of COUNT function, which counts the number of all recurrences, COUNT DISTINCT only considers distinct values. It's a handy tool for getting precise counts and insights from your data, especially when dealing with datasets that might contain duplicate entries.