ProgrammingLooking for feedback on my project
Posted:

ProgrammingLooking for feedback on my projectPosted:

CriticaI
  • TTG Addict
Status: Offline
Joined: Nov 05, 201311Year Member
Posts: 2,749
Reputation Power: 452
Status: Offline
Joined: Nov 05, 201311Year Member
Posts: 2,749
Reputation Power: 452
Hello programmers on TTG,

I recently created a side project to help me with Python. The project can be found on the GitHub. However, I do not know if I should continue this project or move on to something else. I'm looking for feedback but let me tell you a little bit about what it does.

If you are familiar with projects that need a database, you are probably familiar with ORMs. An ORM allows you to write your queries using classes and methods. Then you can change to another database on the fly like SQLite, MySQL, and PostgreSQL. I use ORMs all the time, but there are some big flaws. For example, what if I wanted to switch to NoSQL or I wanted to change programming languages? There are a lot of hoops to go through which can cost money and time.

This is why I decided to write my own universal query language. I wanted a way to write queries once, then just change the driver to run the same queries on another database. I wanted to have the concept of an ORM while keeping things simple and improving scalability and maintainability.

My idea was to provide the grammar and tokens. Then, developers can write drivers to convert my universal query language to SQL, NoSQL, Oracle, flat files, etc. I also imagined my grammar being implemented in other languages like NodeJS, PHP, C#, VB, etc.

I already created the basics and provided some proof of concepts for querying with JSON and SQLite. What do all of you think? Would you use this project if it were stable?


Last edited by CriticaI ; edited 1 time in total
#2. Posted:
Fold
  • Moderator
Status: Offline
Joined: Oct 01, 201113Year Member
Posts: 2,844
Reputation Power: 19778
Motto: Brandon has stopped paying for his motto advertising space. This motto is now vacant.
Motto: Brandon has stopped paying for his motto advertising space. This motto is now vacant.
Status: Offline
Joined: Oct 01, 201113Year Member
Posts: 2,844
Reputation Power: 19778
Motto: Brandon has stopped paying for his motto advertising space. This motto is now vacant.
That sounds like a super interesting project. I hop between Microsoft SQL Server and MySQL frequently and I've never even heard of ORMs to be honest. So using a ORM I'd be able to just seamlessly switch between those two dbms? That could be super useful and I'd absolutely take advantage of it!
#3. Posted:
CriticaI
  • Supporter
Status: Offline
Joined: Nov 05, 201311Year Member
Posts: 2,749
Reputation Power: 452
Status: Offline
Joined: Nov 05, 201311Year Member
Posts: 2,749
Reputation Power: 452
Fold wrote That sounds like a super interesting project. I hop between Microsoft SQL Server and MySQL frequently and I've never even heard of ORMs to be honest. So using a ORM I'd be able to just seamlessly switch between those two dbms? That could be super useful and I'd absolutely take advantage of it!


Yes, ORMs are pretty useful, but they can be limiting and/or overwhelming. For example, here is one for NodeJS sequelize.org/master/

But, as you can see this library is very complex. You have to read a lot of documentation and it only supports Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. Then what if you didn't want to use NodeJS?

Hopefully with my project I could support more databases and keep the code simple.
Users browsing this topic: None
Jump to:


RECENT POSTS

HOT TOPICS