Skip to content
logo

DbSchemaLibrary Project Update #2

Author

Michael Salim

@IamMichaelSalim

Hello,

This is a Christmas and the 2nd project update for DbSchemaLibrary 🎄. Merry Christmas! If you missed the first one, you can read it here.

It has been a while since my last update. In my previous email, I mentioned that I hoped the next update would be about early access to the platform. It has taken longer than expected to get to this point, but here we are at last 😁

#1 Beta Access

Some of you should have received an email about accessing the beta platform. If you did, please try it out and let me know what you think! I am looking for feedback on what you found useful, what is lacking, and what we can improve on.

If you haven’t received the email yet, you should receive it shortly!

#2 Birth of the Platform

There’s so much to talk here. As you can tell from the beta, there’s now a platform you can go to to access all the data. We’ve done a lot of work here to make it easy to use.

For example, you can read the schema in a variety of format:

First is the DDL/SQL format, with the option to choose your preferred dialect.

DDL/SQL

If you are a visual learner, you can view the data in an ERD relationship diagram.

ERD

And if you just want a quick overview, you can read the table preview.

Table Preview

We are committed to making data accessibility a key focus of our platform. After all, what’s the use of data if you can’t make sense of it?

In the future, we may look into adding support for common ORMs such as Laravel’s Eloquent, Django’s ORM and Prisma.

#3 Module Patterns

Modules are great. They let you search specific features you want to implement. However, we found that it is even better if we highlighted common patterns in that module. This way, you can avoid having to search through multiple schemas and implementations to find the right one.

Here’s an example of how it looks like for the User Authentication module:

Module Patterns

This takes a lot of effort from our part so I hope it’s useful!

#4 Fun Features – Themes

Aside from the serious stuff, we’ve also added various themes you can choose from while reading the schema. These themes are purely for fun but I can’t resist the temptation to add them! What’s your favorite theme?

Themes

Thanks again for your interest in DbSchemaLibrary. We are always open to suggestions, so if you have any ideas for features you would like to see, please let us know!