DEV Community

Introducing Verse.db: The Next Generation of Lightweight, High-Performance Databases

Marco Maher on May 27, 2024

Hey Dev.to community! I'm excited to introduce you to Verse.db, a cutting-edge database solution designed to meet the needs of modern developers w...

Read full post

Vaviloff • May 28

What's so "cutting edge" about this database and how does it differ from Postgres and the like?

Marco Maher • May 28 • Edited

Hi Vaviloff,

Thank you for your question.

Verse.db stands out for several reasons that make it "cutting edge" compared to traditional databases like PostgreSQL:

Simplicity and Ease of Use: Verse.db is designed to be exceptionally user-friendly, with a focus on ease of setup and use. It doesn't require extensive configuration or complex setup procedures, making it accessible even for those who are not database experts.
Local Data Storage with Enhanced Security: Unlike PostgreSQL, which typically requires a server environment, verse.db saves data locally in SQL files. These files can be encrypted and encoded into .verse files, offering an additional layer of security and reducing the data size.
Integrated Development Experience: Verse.db aims to streamline the development process by integrating smoothly with other tools and platforms. This integration allows for more straightforward management of database operations within development workflows.
Upcoming Features and Improvements: We are continually working on enhancing verse.db. The upcoming versions (2.4 or 2.5) will include a new SQL adapter that addresses current bugs and provides a more robust and efficient database experience.

While PostgreSQL is a powerful and highly reliable database system suitable for many use cases, verse.db offers a simpler, more secure local storage solution with features that are particularly beneficial for specific use cases and environments.

We hope this gives you a clearer picture of what makes verse.db unique. If you have any more questions, feel free to ask!

Vaviloff • May 28

Marco, thanks for your reply!

To be honest most of your points are quite general, maybe even too vague: they sound nice, but can mean anything and nothing. It would be so interesting to learn something much more specific about your BD. Like you know how they teach writers to create better books? "Show, don't tell!"

It doesn't require extensive configuration or complex setup procedures, making it accessible even for those who are not database experts.

I wonder how does it make setup more accessible? I feel like launching a new Postgres/MySQL/Mongo/ in a Docker container is already easy enough, wouldn't you agree?

Verse.db aims to streamline the development process by integrating smoothly with other tools and platforms

I'm all of smooth integrations, there's not enough of it in the modern world! But how is Verse.db doing that? 🤔

verse.db saves data locally in SQL files

It would be very exciting to learn why does it matter and what kind of SQL files are those. Maybe you could share an example of such a file.

Upcoming Features and Improvements

Is "Upcoming Features and Improvements" also a cutting edge feature? 😅

Marco Maher • May 28 • Edited

Hi Vaviloff,

trust me in version 2.4-2.5 not only a new SQL adapter there is a new way and a new way of databases coming out trust me you will like it so much,
i can give you an example of what is cutting edge feature coming in the look at this

@enity Users {
  @description "description",
  @schema {
    id: Number | String;
    name: String;
  },
  @constraints{
    id: {
      default: "id",
      minLength: 2;
      maxLength: 15;
      unique: true;
    },
    name: {
      default: null;
      required: true;
      minLenth: 3;
    }
  }
  @enteries {
    (1, "Marco"),
    (2, "Vaviloff"),
  },
};

that's a leak of the new data language we are working on my friend keep it a secret just between you and me 🤫

Vaviloff • May 29

It does indeed look interesting and slightly reminds me of Prisma schema/models. So is Verse.db going to be an ORM like Prisma or Drizzle, or an adapter for JSON/SQL data storages like KeyV library?

Marco Maher • May 29

This is going to be a new language like json, sql we are still trying to figure a name for it we decided first to use "SQON" Name for "Structure Query Object Language" we are still working on it and you can just say it's like typescript for JavaScript it will have a terminal command to compile it with it's config file to be compiled to json or sql depending on the config you setup and it will have a reader to just use it like any other language without compiling

Marco Maher • May 29

Also after we publish our new language there is going to be a new adapter for it since we made it to be faster in reading data and less sized than sql and json files

Christian Pham • May 28

Hi Marco,

It's great that verse.db can connect to a sql database via sql adapter. However, let me ask, is the sql database here a local database (sql express) or a server database? If it is possible to connect to both, how should the connectionstring be configured?

Marco Maher • May 28

Hi Christian Pham,

Thank you for your interest in verse.db and your question regarding the SQL adapter.

To clarify, verse.db currently saves data locally in SQL files (e.g., data.sql). You can enable security features to encrypt and encode this data, storing it in files with a .verse extension for better security and reduced size.

However, I would not recommend using the current SQL adapter, as we have identified a bug in it. We are currently in the process of rebuilding the SQL adapter to make it more user-friendly and efficient.

The new and improved SQL adapter is planned to be released in version 2.4 or 2.5, and it shouldn't take long for these updates to become available. We appreciate your patience and understanding during this transition period.

If you have any further questions or need assistance, please feel free to ask.

Mark Thomas • Jun 20

Can you used JSON comparison tools to find changes in the database?

Anas Khalid • Jun 22

Regarding comparison, do u mean to compare two JSON file with their data inside of them or between two set of documents? moreover the word comparison can be meant a lot in database will it compare data size of two JSON or compare specific key and their values?

Mark Thomas • Jun 24

I was thinking JSON files and the data in those files stored in the database. That could apply also apply to other file types like Word, DITA, or PDF.