News for hackers. Stuff that matters.
Re:I made nodb, a RESTFful API to store and fetch JSON by ralusek on Thursday June 01, 2023 @11:06AM (#36152098)
This is the case for every database, but they still tell me what indexing options I have available.

With an RDBMS I know that I can use hash key indexes for fast lookups on an exact key. I can use B-Tree indexes for range or partial key lookups.

For S3 I know that I can do exact lookups, or prefix scans, and that scans occur in ascending order, but cannot be done in descending order, etc.

I know nothing of what lookup schemes are available to me in your application, and what kind of Big O profile to expect from each. It has nothing to do with whether it's a grocery app or a movie app.

Re:I made nodb, a RESTFful API to store and fetch JSON by mk0y on Friday June 02, 2023 @03:58AM (#36162395)
First of all nodb isn't meant for really large scale applications. I will have to do a research on how to it best and simplest way possible. The idea behind nodb is simplicity - you start inserting data in no time. Indexing of what you talk about is currently not possible. I will definitely look into it though and restructure it if necessary. Thanks for elaborating and the feedback, much appreciated. I will post again when I have updates.