Re:Datasette is my data hammer
by brunooliv on Wednesday January 18, 2023 @02:08AM
(#34424177)
Can Datasette be used with a Postgres RDS database with hundred GBs? Feels like it's mostly designed for smaller things? Also if it can, how would I go about it and if it can't, any similar tools I can use? This looks really cool!!
[ Parent
| on HN ]
It's just for sqlite databases.
You can easily put a hundred GB or two into a SQLite database
Re:Datasette is my data hammer
by craftsquick on Wednesday January 18, 2023 @03:38AM
(#34424674)
This is a self-plug but shapedata.io does similar things on top of Postgres -- it is much younger than Datasette, so has far fewer features, but should give you a similar exploration experience!
I'm keen to check this out, I tried to sign up but got a 403 during the google auth flow.
Along with the message: The developer hasn’t given you access to this app. It’s currently being tested and it hasn’t been verified by Google. If you think you should have access, contact the developer
Re:Datasette is my data hammer
by craftsquick on Wednesday January 18, 2023 @04:32AM
(#34424927)
Really sorry about that -- I should've turned off test mode now for Google OAuth. Login work ok now?
Yep, in now. Will play with it tomorrow. Thanks, looks like a great project.
Will give it a try! Want to use it on top of replicas of our work production DB like in an exploration day setting and see what comes out of it, looks awesome!!
I have a sister project to Datasette called Django SQL Dashboard which works against PostgreSQL databases: https://django-sql-dashboard.datasette.io
It used Django for the authentication layer but can otherwise work against any PostgreSQL database.
I partly built it to help explore what Datasette could look like if it expanded to work with more databases than SQLite. That's still something I'm considering doing in the future, via a plugin hook, but it's not on my short-term roadmap.