Retool Database • Hacker News Board

Re: Retool Database

#51

Post by austinjp » Fri, Mar 31, 2023, 7:54 AM UTC

Congrats. Looks like it will be useful for plenty of folks. Can you outline how it compares with e.g. NocoDB [0] and others mentioned in another comment [1]?

As for "getting started" speed and general data tinkering, I find little beats Gnumeric -> CSV -> SQLite query [2] although I appreciate that solo developers aren't your target market :)

[0] https://github.com/nocodb/nocodb

[1] https://news.ycombinator.com/item?id=35381252

[2] https://til.simonwillison.net/sqlite/one-line-csv-operations

Re: Retool Database

#52

Post by zem » Fri, Mar 31, 2023, 7:58 AM UTC

dmarble wrote: post #37

ithrow wrote: post #5

Earlier quoted context omitted.

Can Retool Database be self-hosted stand-alone without Retool? I can see using this as a replacement for excel on some things.

Check out: NocoDB ( https://github.com/nocodb/nocodb ) - works w/ MySQL, PostgreSQL, SQL Server, SQLite, MariaDB Baserow ( https://gitlab.com/bramw/baserow ) - PostgreSQL based APITable ( https://github.com/apitable/apitable ) - MySQL based

thanks, I've been looking at all the spreadsheet-over-a-database projects i can find, and hadn't discovered APITable yet! I have a very specific requirement (app where I want a few views to be collaborative spreadsheets and the rest more freeform html based pages reading from the same tables) and so far none of the popular projects has been quite suitable. (basetool might have but it's dead :()

Re: Retool Database

#53

Post by orthoxerox » Fri, Mar 31, 2023, 9:11 AM UTC

dmarble wrote: post #37

ithrow wrote: post #5

Earlier quoted context omitted.

Can Retool Database be self-hosted stand-alone without Retool? I can see using this as a replacement for excel on some things.

Check out: NocoDB ( https://github.com/nocodb/nocodb ) - works w/ MySQL, PostgreSQL, SQL Server, SQLite, MariaDB Baserow ( https://gitlab.com/bramw/baserow ) - PostgreSQL based APITable ( https://github.com/apitable/apitable ) - MySQL based

There's also Grist (https://getgrist.com) - SQLite based with Excel-like formulae in Python.

I run it on my NAS as my own private Airtable for calorie tracking.

Re: Retool Database

#54

Post by seancolsen » Fri, Mar 31, 2023, 12:33 PM UTC

dmarble wrote: post #37

ithrow wrote: post #5

Earlier quoted context omitted.

Can Retool Database be self-hosted stand-alone without Retool? I can see using this as a replacement for excel on some things.

Check out: NocoDB ( https://github.com/nocodb/nocodb ) - works w/ MySQL, PostgreSQL, SQL Server, SQLite, MariaDB Baserow ( https://gitlab.com/bramw/baserow ) - PostgreSQL based APITable ( https://github.com/apitable/apitable ) - MySQL based

Also Mathesar (https://github.com/centerofci/mathesar/) - PostgreSQL based

Re: Retool Database

#55

Post by johnthescott » Sat, Apr 01, 2023, 5:20 AM UTC

atonse wrote: post #41

winrid wrote: post #28

Earlier quoted context omitted.

You'll see a performance benefit way before 100k rows depending on the size of each row, especially with sorting. It might save you guys a ton of CPU hosting wise, depending on how this all works, to track slow queries and auto add indexes. Way worth the write overhead in most cases.

It’s likely that most of their customers would only have a few hundred or thousand rows where indexing may not actually matter after all. Otherwise I’m sure they would’ve prioritized it.

huh? what about joins? surely your customers are doing joins. a few thousand times a few thousand is >> 1 million.