News for hackers. Stuff that matters.
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!!
Re:Datasette is my data hammer by jboynyc on Wednesday January 18, 2023 @02:59AM (#34424441)
It's just for sqlite databases.
Re:Datasette is my data hammer by lsb on Wednesday January 18, 2023 @03:28AM (#34424609)
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!
Re:Datasette is my data hammer by Fuzzwah on Wednesday January 18, 2023 @04:02AM (#34424798)
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?
Re:Datasette is my data hammer by Fuzzwah on Wednesday January 18, 2023 @05:09AM (#34425119)
Yep, in now. Will play with it tomorrow. Thanks, looks like a great project.
Re:Datasette is my data hammer by brunooliv on Wednesday January 18, 2023 @05:41AM (#34425284)
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!!
Re:Datasette is my data hammer by simonw on Wednesday January 18, 2023 @07:14AM (#34425806)
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.