Hacker News new | past | comments | ask | show | jobs | submit login

That's just a lookup table, not a database.



At least to be fair he is comparing with Postgres.

I'm still unsure whether a database would benefit me, or if keeping everything flat is easier for ~50GB on a single machine. I'm leaning towards yes, as does the article, but my log files do not need much maintenance so I do not make persistent transformations.


"A database is an organized collection of data."

By definition. First sentence in wiki. I don't know what are your definitions.


I could be misinterpreting but I believe a lookup table is more of a suggestion than anything.

It would be easier than for instance a hash table, or rather in networking, a deterministic solution is more common.

I'm obviously not a systems programmer though so I can't provide much else.


If you want to call a lookup table a database I'm ok with that.


But that means I'm writing my own databases at least a couple times a year. I'm not sure I'm okay with that.


yeah, just a hash table would suffice


It was actually simpler, I have packed from and to range into uint64, added data offset, ordered at generation of db file and searched using bisection. Used the fact that ip is just a uint32 and range can fit into one register on 64 bit machine. Fixed size range (+data) enabled me to calculate position in file so bisection was simple.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: