Latest blog post: The Best Analytics and Data Science Tools to Use Depending Your Needs and Experience Level
Dropbase lets you upload datasets into production databases and quickly get credentials that can be used to query the database using a SQL editor.
We initially built Dropbase for our internal use. We were building database integrations for one of our products and had to manually do this process multiple times to create live databases and seed them with relevant data. Dropbase is useful if you're building a web application and need a quick way to add some of your own data for testing on a deployed database. It's also useful if you have a CSV file that you want to query through SQL instead of spreadsheet filters.
PostgreSQL.
The current version of Dropbase only supports CSV files structured with header columns. We do some data type inferencing for dates, numbers and strings, but we are not able to restructure CSV files.
Make sure you reformat your CSV file to have headers for each column in the first line. Dropbase won't be able to upload files without column headers.
For best results, use the following best practices for your CSV files:
Please don't upload any data that is sensitive or that contains private information.
Check your spam folder for an email from this address: jimmy@email.castodia.com. We might send future updates from that email as well. Please mark our email as not spam.
We'll keep your data temporarily and delete it afterwards. We'll host data in our database for a week and purge all database tables on a weekly basis. If you'd like us to host your data for a month, enter your email in the email address field after you've uploaded your data. If you want us to host your data for longer, please contact us at dropbase@castodia.com.
No. We won't look at it, use it, or save it beyond the specified time above, unless you request it. We run some automated processing on the data to make sure it can be properly uploaded into the database.
Only if you copy the credentials as soon as you get them, or if enter your email in which case we'll email you your credentials. Otherwise, if you close the page before copying or entering your email, you would have to start over again.
Yes, although features are limited at the moment. We may build additional features and charge for them in the future. For example multiple database tables with the same username and password. Let us know if you'd like other features.
Not unless you share database credentials with them. We generate new usernames and password each time you upload a new file.
Not at the moment.
Maximum CSV file size is 150MB.
Yes. Tell us your use case. Reach out to us at dropbase@castodia.com
If you like Dropbase but need additional features to make it more useful for your use case or if you would like to provide us with some feedback, please let us know. Either fill up our survey or email us at dropbase@castodia.com. We'd love to hear from you.
Try Castodia free for 14 days, no credit card required.
