another quick update
I've changed the create statement so it looks more like SQL, so now you have to be specific about creating a table.
I did this because I will start the indexing algorithm tomorrow and therefore, I will need the create statement to also recognize "create index".
I have also created a new feature, the bulk insert
it's kinda bad when working with LQL, because you actually have to type the JSON in the command line:
HOWEVER, when you want to insert an array it's waaaaaaaaaaay faster than inserting one document at a time, here is a test of my inserting 1k documents:
during my tests I had a bad time trying to insert 10k documents one at a time, it took almost a minute
and testing the bulk insert, I could insert 1M documents in 2s
I do not know how useful a bulk insert will be on a day-to-day basis, but I have created it so I can test my indexing algorithm once it's done, so I can quickly create huge databases and test how indexing will affect them
bulk insert is nice and fast
very excited to start indexing tomorrow
Repository for the database/driver/REPL:
Repository for the LQL parser:
Repository for the test I've made for this post: