Subscribe
Sign in
p/ui-bakeryLow-code internal tool builder
Start new thread
Vladimir Lugovsky

SQL playground - Free private sample PostgreSQL databases

by•

Create a private PostgreSQL database with a predefined structure & test data in the shortest time. No local installations or spinning up cloud instances. Choose a database type, and get a unique connection string right away.

Add a comment

Replies

Best
Vladimir Lugovsky
Maker
Hi PH community 👋! We at UI Bakery quite often need a sample SQL database for testing purposes. It's even better when this database has some predefined structure and meaningful data in it. We've had a couple of such schemas as SQL scripts, but this was not always convenient because someone also needs to set up a database instance where you execute them, manage access between different users and bases, etc. In the end, we came up with a solution that we are happy to share with the community today! Our tool allows selecting a type of database that you want to work with, and you receive the connection string right away. As simple as that! No need to sign up, create a VM, install the PostgreSQL server, enter your credit card details, and so on. You can use this tool to play with sample data from your favorite programming language or from any low code tool that supports PostgreSQL connection. Let me and my team know if you have any questions, and I really appreciate any feedback!
Anass Limon
Just useful
Husnain Akmal
Hi! Please join me see what it is all about. Thank you.
Wax
Here's some SQL to get the tables in each database: https://gist.github.com/mike-wax...
Vladimir Lugovsky
Maker
@waxdotrun thank you for sharing this! We will definitely fix. Anyway, they all are test databases and we don't advise to use them for production purposes.
Wax
@vladimir_lugovsky fix what? The query above is just so someone can see the tables and columns in each database.
Vladimir Lugovsky
Maker
Oh, I just thought that this is a security issue since by default this tool should only provide access to a single database without ability to view the metadata
Ghost Kitty
Comment Deleted