search

cools9 / ElementalDB

A database made in python meant to be superfast and easy to learn for beginners and meant to be a sql,sqlite and postgres competitor
MIT License
11 stars 11 forks source link

How to get filtered records? #9

Open Qoyyuum opened 2 weeks ago

Qoyyuum commented 2 weeks ago

Say for example I have a list of products and they're all in categories. How do I filter and get a list of products filtered per category that I want to display?

cools9 commented 2 weeks ago

Well that's under dev but it's a good point

cools9 commented 2 weeks ago

For now it's simple just get the entire data and then filter it according to your needs using if else or whatever

Qoyyuum commented 2 weeks ago

That's not ideal. If there's millions of records then I'd be creating an unnecessary memory workload on the database server, and wait a long time to get a response back.

On Mon, 7 Oct 2024 at 18:43, Rishabh SIngh @.***> wrote:

For now it's simple just get the entire data and then filter it according to your needs using if else or whatever

— Reply to this email directly, view it on GitHub https://github.com/cools9/ElementalDB/issues/9#issuecomment-2396565680, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAHNELPVKNQ25S6UZBALUYTZ2JQWXAVCNFSM6AAAAABPPHUSRKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGOJWGU3DKNRYGA . You are receiving this because you authored the thread.Message ID: @.***>

-- Abdul Qoyyuum Bin Haji Abdul Kadir Nickname: Q More about me: https://buymeacoffee.com/qoyyuum

cools9 commented 2 weeks ago

I know I'm working on it