5 ms·
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
by brunooliv 4y ago
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!!
- jboynyc 4y agoIt's just for sqlite databases.
- lsb 4y agoYou can easily put a hundred GB or two into a SQLite database
- craftsquick 4y agoThis 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!
- Fuzzwah 4y agoI'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
- craftsquick 4y agoReally sorry about that -- I should've turned off test mode now for Google OAuth. Login work ok now?
- Fuzzwah 4y agoYep, in now. Will play with it tomorrow. Thanks, looks like a great project.
- brunooliv 4y agoWill 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!!
- simonw 4y agoI have a sister project to Datasette called Django SQL Dashboard which works against PostgreSQL databases: https://django-sql-dashboard.datasette.io 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.