ezDB | Devpost

Inspiration

We love using document-based databases such as MongoDB. We just wish they were better. More often than not, they aren't built with serverless in mind, have a terrible developer experience, and are unreliable.

What it does

ezDB is full full-fledged cloud storage solution, providing a database built on top of CockroachDB and a developer dashboard bundled with a smart AI assistant. The database includes an HTTP-API layer and a Schema system, and the dashboard contains an items explorer and UI for editing tables/databases. As a developer, in one click, you can create your database, in another, your table, and with one line of code, you can begin adding items right away. Stuck? The AI assistant customized to your database's data will help you!

How we built it

ezDB uses CockroachDB as its "engine", with all documents stored there. Deno KV is used as a temporary cache to keep track of user metadata and document references. The website front-end is written with Typescript and React. The AI assistant is built on top of ChatGPT. GitHub OAuth is used for login.

Challenges we ran into

The sheer size of the project was quite a bit. ezDB aims to be a full cloud solution, providing not just the database but also all the tooling to explore the data within it, create tables, and a generally seamless UI. The caffeine definitely helped...

Accomplishments that we're proud of

Not only does our solution work, we think it looks great as well. Design is paramount when creating any product, and the website we created is both slick and informative. It feels easy to use ezDB, which was our goal.

What we learned

We learned a lot about SQL querying (something we were all a lot less familiar with), performance challenges behind databases, and CockroachDB in general.

What's next for ezDB

There is a lot of polishing left to do before ezDB can go into production. Security needs to be analyzed, proper error handling must be installed, and further features integrated into the developer dashboard. We aim to do all this and convert ezDB into a real solution for other developers like us.