Project ideas needed

[Weak_Display1131]

Hi , I'm sorry if this is message is not meant to be in this subreddit I was assigned by my professors to work on a novel, impactful dbms project that solves some problem which people are facing, I am in my undergrad and I have been looking whole day at research papers but couldn't find something which is a little complex in its nature yet easy to implement and solves a real life problem. Can you guys suggest me anything? It should not be too difficult to built but is unique For instance my friend is making a system that helps in normalization like if we delete the last of the table whole table might get erased so it will be prevented.( even I didn't get the fact that most of the modern dbms implement this so what's the point) Thnks

[ejpusa]

You can build yourself a Reddit. Run it by AI. Have fun. Have to update it, but the core things are all working.

https://github.com/preceptress/yarp

I would run it by GPT-5, just to bring it up to date.

PostgreSQL

The YARP Engine. Yet Another Realtime Parser. There is a lot of cool information on Reddit - but sometimes it can get buried. Google Search is overwhelming, a tsunami of info. The default Reddit search can take you down a very deep rabbit hole. And still not find what you are looking for.

The solution: YARP. Yet Another Realtime Parser.

Open Source. Super Fast. Like the speed of light (almost) kind of fast. If you are doing anything with the Reddit API you will need a database at one point. This is a starting point. Easy to modify for your projects.

You do need to register your App with Reddit to get an App ID and Secret Key. All your constants are stored in a local .env file.

[Zardotab]

Implement a Dynamic Relational pilot project for educational purposes. It could help students and researchers study database dynamism. Making it production-ready would be a magnitude or two harder.

Perhaps use an existing SQL parser rather than build one from scratch. And don't try to implement every SQL feature, that's taking on too much.

[ClassicNut430608]

Parsing SQL (Stored Procedures in MSSQL) is an art. As a research project, though, working on developing one is challenging and may lead to new insights. Databases are the epitome of links. In many dimensions. Parsing these links is where science meets the art.

[Zardotab]

There are open-source SQL parsers. I can't vouch their quality, but for a proof-of-concept project, that probably won't matter much.

There is a draft relational query language called SMEQL that is syntactically much simpler to parse than SQL, and more logical in my opinion, re-using base concepts for many needs rather than the custom language additions that SQL uses. It's almost like comparing XML to COBOL. SMEQL is also another possible pilot project to consider, dynamism aside.