🦞🌯 Lobster Roll

Thread

How Materialize and other databases optimize SQL subqueries (scattered-thoughts.net)
L 27 pts 0 comments by tbonesteaks Feb 17, 2021 databasesperformance thread

Stories related to "How Materialize and other databases optimize SQL subqueries" across the full archive.

How Materialize and other databases optimize SQL subqueries (scattered-thoughts.net)
L 27 pts 0 comments by tbonesteaks Feb 17, 2021 databasesperformance Data / Databases / Infrastructure thread
How the PostgreSQL optimizer works to speed up queries (cybertec-postgresql.com)
L 5 pts 0 comments by friendlysock Jan 3, 2024 databasesperformance Data / Databases / Infrastructure thread
Ten years of improvements in PostgreSQL's optimizer (rmarcus.info)
L 16 pts 0 comments by sanxiyn Apr 17, 2024 databasesperformance Data / Databases / Infrastructure thread
PGWatch: Optimized PostgreSQL monitoring (pgwatch.com)
L 3 pts 0 comments by xvello Oct 29, 2025 databasesperformance Data / Databases / Infrastructure thread
A vendor-independent comparison of NoSQL databases: Cassandra, HBase, MongoDB, Riak (networkworld.com)
L 2 pts 1 comments by selenamarie Nov 2, 2012 databases Data / Databases / Infrastructure thread
Test Automation for NoSQL Databases with NoSQL Unit and Travis-CI (blog.codecentric.de)
L 1 pts 0 comments by lauris May 15, 2014 databases Data / Databases / Infrastructure thread
Practical Persistence in Go: SQL Databases (alexedwards.net)
L 9 pts 0 comments by journeysquid Jun 18, 2015 databasesgo Programming (General)Data / Databases / Infrastructure thread
MongoDB: The Frankenstein Monster of NoSQL Databases (linkedin.com)
L 4 pts 0 comments by jdegoes Mar 14, 2016 databases Data / Databases / Infrastructure thread
Q: What happens when you can't design a composable query language? A: You get MongoDB, with 3 bad query languages that still can't do ad hoc queries over JSON.
MyRocks: A space- and write-optimized MySQL database (code.facebook.com)
L 6 pts 0 comments by sanxiyn Sep 1, 2016 databases Data / Databases / Infrastructure thread
IntegriDB - Verifiable SQL for Outsourced Databases (2015) (umiacs.umd.edu)
L 1 pts 0 comments by nickpsecurity Feb 7, 2017 cryptographydatabasespdfsecurity Data / Databases / InfrastructureSecurity / Privacy thread
Usql: universal command-line interface for SQL databases (github.com)
L 1 pts 0 comments by av Mar 3, 2017 databasesgo Programming (General)Data / Databases / Infrastructure thread
Schemats v2.0 - TypeScript interface generator for Databases now supports MySQL! (github.com)
L 4 pts 0 comments by xiamx Apr 21, 2017 databasesnodejs Web DevelopmentData / Databases / Infrastructure thread
Building Searchable Encrypted Databases with PHP and SQL (paragonie.com)
L 4 pts 0 comments by inactive-user May 26, 2017 cryptographydatabasesphpsecurity Programming (General)Data / Databases / InfrastructureSecurity / Privacy thread
Materialized View Strategies Using PostgreSQL (hashrocket.com)
L 7 pts 0 comments by friendlysock Jul 5, 2017 databasesperformance Data / Databases / Infrastructure thread
JOIN Elimination: An Essential Optimiser Feature for Advanced SQL Usage (blog.jooq.org)
L 5 pts 0 comments by calvin Sep 1, 2017 databasesperformanceprogramming Programming (General)Data / Databases / Infrastructure thread
Distributed Algorithms in NoSQL Databases (highlyscalable.wordpress.com)
L 5 pts 0 comments by unbalancedparentheses Sep 17, 2017 databasesdistributed Programming Languages / CS TheoryData / Databases / Infrastructure thread
10 Cool SQL Optimisations That do not Depend on the Cost Model (blog.jooq.org)
L 13 pts 2 comments by calvin Sep 29, 2017 databasesperformance Data / Databases / Infrastructure thread
How to support full Unicode in MySQL databases (mathiasbynens.be)
L 1 pts 0 comments by fs111 Oct 27, 2017 databases Data / Databases / Infrastructure thread
Analyzing the Performance of Millions of SQL Queries When Each One is a Special Snowflake (heap.engineering)
L 2 pts 0 comments by malisper Nov 27, 2017 databasesperformancescaling Data / Databases / InfrastructureProductivity / Career / Business thread
COST in the land of databases (github.com)
L 7 pts 0 comments by hwayne Nov 29, 2017 databasesperformance Data / Databases / Infrastructure thread
MongoDB vs MySQL: A Comparative Study on Databases (simform.com)
L -1 pts 0 comments by RohitAkki Nov 30, 2017 databasesprogramming Programming (General)Data / Databases / Infrastructure thread
It is my first article on lobste.rs, I hope you will enjoy my contribution. Do not hesitate to comment and help to improve it.
PostgreSQL benchmark on FreeBSD, CentOS, Ubuntu Debian and openSUSE (redbyte.eu)
L 4 pts 4 comments by friendlysock Dec 28, 2017 databasesperformance Systems / Low-Level / OSData / Databases / Infrastructure thread
Yesquel: Scalable SQL Storage for Web Applications (2015) (cs.nyu.edu)
L 1 pts 0 comments by nickpsecurity May 7, 2018 databasespdfperformanceweb Web DevelopmentData / Databases / Infrastructure thread
Abstract: "Web applications have been shifting their storage systems from SQL to NOSQL systems. NOSQL systems scale well but drop many convenient SQL features, such as joins, secondary indexes, and/or transactions. We design, develop, and evaluate Yesquel, a system that provides performance and sca...
Big News In Databases: SQL Still on The Rise, Cloud First, Fsyncgate and a Giant Leap for SQL (winand.at)
L 1 pts 0 comments by dege Jul 4, 2018 databases Data / Databases / Infrastructure thread
Fast Full-Text Search in PostgreSQL (austingwalters.com)
L 3 pts 0 comments by calvin Aug 29, 2018 databasesperformance Data / Databases / Infrastructure thread
Parallel Hash for PostgreSQL (write-skew.blogspot.com)
L 5 pts 1 comments by calvin Sep 30, 2018 databasesperformance Data / Databases / Infrastructure thread
Introducing PMDK into PostgreSQL (pgcon.org)
L 8 pts 0 comments by cleong Nov 13, 2018 databasespdfperformance Data / Databases / Infrastructure thread
PostgreSQL Performance on Raspberry Pi 3B (blog.rustprooflabs.com)
L 11 pts 0 comments by nickpsecurity Apr 6, 2019 databasesperformance Data / Databases / InfrastructureMaker / DIY / Hardware thread
Fastest Way to Load Data Into PostgreSQL Using Python (hakibenita.com)
L 13 pts 2 comments by Haki Jul 9, 2019 databasesperformancepython Programming (General)Programming Languages / CS TheoryData / Databases / Infrastructure thread
Automatic Index Recommendations in PostgreSQL using pg_qualstats and hypopg (percona.com)
L 12 pts 0 comments by mulander Jul 23, 2019 databasesperformance Data / Databases / Infrastructure thread