Since you mentioned it, I was always curious if the team behind TablePlus were/are connected to the team behind Postico [1]. The UIs for both (at least before Postico 2) are almost identical. [1] https://eggerapps.at/postico2/. - Source: Hacker News / 9 months ago

Postico is a native Mac app for Postgres databases (and some compatible databases including Amazon Redshift, CockroachDB, Greenplum, and others). It's a Mac-only app, and the UI reflects it. The person behind Postico is the same developer who built postgres.app, which starts a Postgres server on your Mac. - Source: dev.to / 9 months ago

Sequel pro could be compared with postico2 as far as native look and feel go - https://eggerapps.at/postico2/. - Source: Hacker News / 9 months ago

Also I recommend you using Postico or Table Plus with your Relational Databases, believe me it's a lot more easier to surf through your DB if you have tool like this. - Source: dev.to / over 1 year ago

Postico is macOS PostgreSQL client for reading data, doing basic manual data entry and editing your database structure. - Source: dev.to / about 2 years ago

> Make diff work on more than just SQLite. Another way of doing this that I've been wanting to do for a while is to implement the DIFF operator in Apache Calcite[0]. Using Calcite, DIFF could be implemented as rewrite rules to generate the appropriate SQL to be directly executed against the database or the DIFF operator can be implemented outside of the database (which the original paper shows is more efficient).... - Source: Hacker News / 11 months ago

Use a SQL Parser like sqlglot or Apache Calcite to compile user's query into an AST. Source: about 1 year ago

One parser I think deserves a mention is the one from Apache Calcite[0]. Calcite does more than parsing, there are a number of users who pick up Calcite just for the parser. While the default parser attempts to adhere strictly to the SQL standard, of interest is also the Babel parser, which aims to be as permissive as possible in accepting different dialects of SQL. Disclaimer: I am on the PMC of Apache Calcite,... - Source: Hacker News / almost 2 years ago

Apache Calcite can do this, though it's not a beginner-friendly task: https://calcite.apache.org/. - Source: Hacker News / almost 2 years ago

You should look at Apache Calcite[0]. Like OctoSQL, you can join data from different data sources. It's also relatively easy to add your own data sources ("adapters" in Calcite lingo) and rules to efficiently query those sources. Calcite already has adapters that do things like read from HTML tables over HTTP, files on your file system, running processes, etc. This is in addition to connecting to a bunch of... - Source: Hacker News / almost 2 years ago