5 ms·

Just wishing there was no mismatch between idiomatic SQL schemas and idiomatic programming data structures (join (join (join .... Working directly with SQL doe

• anotherhue 3y ago
  There are some middle grounds https://github.com/prql/prql https://github.com/prql/prql
• randomdata 3y ago
  The impedance mismatch comes as a result of needing workarounds for database implementations that exhibit high query latency in order to see the execution finish in a reasonable amount of time. It is not fundamental. You can avoid the mismatch by using a DBMS that provides low-latency queries, like SQLite.
  • anotherhue 3y ago
    To be clear, and I assume you know this, network connectivity is probably a small part of typical query latency. Large joins, sorts, etc, would tend to dominate. Maybe for huge result sets bandwidth might factor in a again but so would the sorts.