Skip to content
logo

DbSchemaLibrary Project Update #1

Author

Michael Salim

@IamMichaelSalim

Hello!

This is a quick project update for DbSchemaLibrary.

When I first posted about this project, I wasn’t expecting much to happen. However, it turns out that there are plenty of you that are interested in this! Perhaps you don’t like designing database schemas like me. Or you want to make sure your schema is perfect. Either way, thank you for registering on the website!

To help understand your use case better, I’ve created a short survey (4 questions only!). I will be grateful if you could take 1 minute to complete them 😁 https://www.surveymonkey.co.uk/r/DGF9DN3

Now for the update:

#1 Collecting schemas from all over!

I spent a lot of my time last week compiling a bunch of schemas. As you can see below, excel is still the king of data! There’s still a lot to do. Cleaning the data, tagging, categorization and dealing with presentation. Yet, I do have to say that it’s progressing very nicely 🎉

Excel of data schema

#2 Dedication to Quality

As I was working on this project, I had a realization. DbSchemaLibrary needs to focus on quality instead of quantity. You can find similar resources if you search into the depths of the internet. They also provide for a multitude of industries. One such case is this: http://www.databaseanswers.org/data_models/

However, those resources are difficult to use because most of the schemas aren’t real. They’re hard to search and are often oversimplified. I wouldn’t want DbSchemaLibrary to turn out that way! So while I’ll focus on covering as many industries as possible, It’s also imperative that the quality is top notch.

I’ve written more about this here: https://dbschemalibrary.com/blog/quality-over-quantity

#3 Schema Search & Categorization

One crucial aspect that needs to be considered is the ease of search. With there being so many different use cases, how would someone find a good schema they can use as reference?

I’ve settled on the concept of Modules. Modules are small parts of an application that are reusable across different systems.

So if say, you’re building a SaaS project. You can find and reference the following modules:

  • User authentication
  • Catalog (for whatever the SaaS is about)
  • API Access
  • Analytics
  • Subscription Payment

Here are the list of modules I plan to provide:

List of modules

Please let me know if you have any feedback or suggestions! I’ve also written more extensively about this in the blog post linked above.

#4 Early Access

With all that out of the way, I’m very excited to release the early access preview to a select few. Hopefully my next email to you will be about that!

Quick reminder: If you haven’t, I would be very grateful if you could spare a minute to complete the survey! 😁 https://www.surveymonkey.co.uk/r/DGF9DN3

Thanks and see you next time!