Creating a database from scratch with Node.js - Day 11

Hello Folks!

another quick update

Changes

Changed create to create table

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".

Created a bulk insert function

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

Conclusion

bulk insert is nice and fast

very excited to start indexing tomorrow

Links:

Repository for the database/driver/REPL:

Repository for the LQL parser:

Repository for the test I've made for this post: