Show HN: Dropbase 2.0 – Turn offline files into live databases
Hey HN,<p>We're happy to introduce Dropbase 2.0! It's a tool that helps you bring offline files, such as CSV, Excel, and JSON files, into Postgres database. You can also process your data before uploading it using a spreadsheet-like interface or by writing a custom Python script. Once your data is in the database, you can query it using any third party tool (credentials will be provided). You can also access your data via REST API (powered by PostgREST) or create custom endpoints to serve a more specific use case.<p>A bit about the tech:<p>Currently, we support .csv, .json, .xls, .xlsx files. For data processing, we use Pandas, so if you are comfortable using Python, you can write your own custom functions to process the data. We also give you a free shared Postgres database to test the tool with (your data is isolated and hidden from others). Each one of these databases come with an instance of PostgREST preinstalled, so you can query your database using REST API ([<a href="http://postgrest.org/en/v7.0.0/](http://postgrest.org/en/v7.0.0/)" rel="nofollow">http://postgrest.org/en/v7.0.0/](http://postgrest.org/en/v7....</a>). You can also generate an access token with an expiry date to share your data with others.<p>There are many more features that we baked into the product. Come check it out, it's open for HN community.