This is a utility I created for a current project I'm working on.
I'm aware other hash table and associative array udfs are out there, but I needed a few specific things.
What started as just a function or two, I decided to just take a couple of hours and put together something I could utilize with other projects a bit more robustly.
This relies on the SQLite.au3. So you'll have to adhere to whatever initialization rules it has ( such as #including the SQLiteDLL.au3 if you don't have your own version of sqlite3.dll you're using and utilizing _SQLite_Startup or _hashlite_Initialize ).
One of the things I needed was the ability to be able to do 1 hash field or many hash fields for my query's.
Now I haven't the foggiest idea on the data adding speed comparison of other like UDFs, that wasn't my concern or my goal.
My goals were simple:
- Create a lookup table that I could use multiple hash fields with
- Create a method that once data was inserted into the hashfield that it could be retrieved quickly
- Maintain the data typing of the variables that were being passed
This is barely tested, if you find issues (there's bound to be plenty) or see optimization options, please let me know, I'll get to them as soon as I can.
Here are some single field hash examples:
HashLite.au3
HashLite.au3
I'm probably missing something...