ModernSQL
modern-sql.com
Actively hiring
Information Technology
Data Architecture
Database Management
Follow
Overview
News
Technologies
Salaries
Products
People
Growth
Financials
Overview
SQL has evolved. Beyond the relational model. Discover it now.
News
Structured Primary Keys
Structured Primary KeysSometimes I hit a wall when optimizing a client's query. Over the years, I realized that most cases fall into two categories: (1) unreasonable expectations based on the cloud bill, not on the infrastructure's power; (2) the primary
Read more
Report
ORDER BY Has Come a Long Way
Order by Has Come a Long WayaLimited support in union, except and intersect legsbExpressions must not contain selected columnsThe order by clause is surely one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are wort
Read more
Report
Order-Equivalent OVER Clauses
Order-Equivalent Over ClausesaOrder-equivalent over clause can produce different row ordersbApparently, the framing must be identical too to make over clauses order-equivalentAt the heart of this article, there is a simple question: Will the following que
Read more
Report
SQL Comments, Please!
SQL Comments, Please!In a program, a comment is a part of the source code that is ignored by the system. Comments are generally used for two purposes: (1) provide background information for future readers of that code, including our selves; (2) deactivate
Read more
Report
WITHOUT OVERLAPS Constraints
Without Overlaps ConstraintsaFunctionality available with exclusion constraintsbWithout keyword for: PERIOD FOR BUSINESS_TIME (…)cUsing the btree_gist extension and a range: BUSINESS_TIME tsrange GENERATED ALWAYS AS (tsrange(start_ts, end_ts)) STOREDSQL s
Read more
Report
Pro access
Upgrade to see all 24 mentions
Upgrade to a paid plan to read every media mention of this company - funding news, awards, product launches and press releases from all the outlets writing about it.
Every media mention and press release
Funding news, awards and product launches
Fresh coverage from every outlet writing about the company
Upgrade now
Cancel anytime. Secure checkout. Instant activation.