HackerTrans
TopNewTrendsCommentsPastAskShowJobs

aaviator42

no profile record

Submissions

[untitled]

1 points·by aaviator42·3 maanden geleden·0 comments

Show HN: Simple and robust key-value flat-file data storage library

github.com
2 points·by aaviator42·5 maanden geleden·0 comments

comments

aaviator42
·3 maanden geleden·discuss
We use SQLite IMMEDIATE transactions, which lock files for writes for a few milliseconds while commiting data to the file. This is not a problem in practice until you reach more than dozens of concurrent writers. StorX configures a default busy timeout of 1.5s, but it can be configured as per your needs. You can also get a lot more out of it by being smart about how you spread your data over DB files (eg: one file per user instead of one for multiple/all users), and also by considering when you call openFile() and closeFile() (eg: keep write transactions short, don't leave a file handler open while running long calculations).
aaviator42
·3 maanden geleden·discuss
SQLite is insanely robust. I have developed websites serving hundreds of thousands of daily users where the storage layer is entirely handle by SQLite, via an abstraction layer I built that gives you a handy key-value interface so I don't have to craft queries when I just need data storage/retrieval: https://github.com/aaviator42/StorX
aaviator42
·5 maanden geleden·discuss
I'm not the first to point this out but the website in question, which is mostly static, could easily be hosted on a VPS for at most a couple hundred dollars a month.
aaviator42
·7 maanden geleden·discuss
I used this to implement <yes-script>, the opposite of <noscript>, to be able to designate sections of a page to be hidden if JS was disabled. You can of course do the same thing with classes, but custom tags are fun.

https://github.com/aaviator42/yes-script
aaviator42
·10 maanden geleden·discuss
Anyone have knowledge on how accessible SVGs are for folks who use assistive technologies?
aaviator42
·10 maanden geleden·discuss
Countless lives over the next decades are going to be lost due to decisions being made by this administration. Deaths and illnesses that otherwise would have prevented using existing frameworks and systems had they not been destroyed.
aaviator42
·10 maanden geleden·discuss
The money doesn't go to the researchers.
aaviator42
·10 maanden geleden·discuss


    think / think hard / think harder / ultrathink 
These are all valid claude commands/tokens to enhance its "thinking" abilities.
aaviator42
·11 maanden geleden·discuss
How do you go about finding a recruiter? (for technical roles like system engineers)
aaviator42
·3 jaar geleden·discuss
I wrote a small PHP library that gives you a key-value storage interface to SQlite files: https://github.com/aaviator42/StorX

I've been dogfooding for a while by using it in my side projects.

And there's a basic API too, to use it over a network: https://github.com/aaviator42/StorX-API