srcreigh

50 ms·

751.
by srcreigh 5y ago
I'm not contradicting you, it is curious what you saw, but this SQLite FAQ does claim that 50k/s inserts on a normal computer HDD is possible. Maybe there was some other resource constraint or configuration somewhere. It is very c
752.
by srcreigh 5y ago
I paid for 1 year membership up front 2ish years ago (this lets you lay by CC) but I'm not gonna do it again
753.
by srcreigh 5y ago
The way I understand this (as a Canadian) is When most voters own homes, politicians increase home prices When (or if) most voters don't own homes, politicians decrease home prices In your understanding, what is the force which breaks
754.
by srcreigh 5y ago
Yeah I think if you are doing 1 txn per second roughly instead of 100s, it may just work fine. I'm curious how it goes so shoot me an email if you want with updates
755.
by srcreigh 5y ago
The VM owns the database. Multiple backend service versions run on that same VM. Usually just one but 2 while migrating traffic to a new version. I haven't figured out details regarding having 2 processes both writing and reading to th
756.
by srcreigh 5y ago
are you ingesting the data under 1 transaction? This is a common SQLite issue as writes aren't slow but transactions are. By default 1 write = 1 txn but you can put millions of writes into 1 txn and get many orders of magnitude speedup
757.
by srcreigh 5y ago
For my personal project I'm planning to use a VM with an SSD. Manually I'll use caddy to switch over to a new running backend service with readiness check. As for scaling if I need it I can increase disk space for the app server o
758.
by srcreigh 5y ago
This is a common problem. Bulk inserts should be done within a single txn if possible. The limit isn't insert throughput, but transaction throughput. I've commented elsewhere here for docs referencing this problem. It's FAQ#1
759.
by srcreigh 5y ago
do you have any details about the situation you were facing?
760.
by srcreigh 5y ago
Considering adobe Photoshop use(d) SQLite for application file format, this could be very far from unusual.
761.
by srcreigh 5y ago
More details please if you have them. What was the throughput? number of transactions? Data size? If you have that thread would be great to see it as well.
762.
by srcreigh 5y ago
Interesting problem. Did you try grouping up transactions? Ex instead of a few hundred million txns, do a few hundred thousand 1000op chunk txns. SQLite is much much faster within a txn. Edit: a several hundred million txns over a few hours
763.
by srcreigh 5y ago
Data loss is a pretty serious problem. Do you have any more information about the situation? Could it have been in the hand spun partitioning logic instead of SQLite? What was the ingestion throughout roughly?
764.
by srcreigh 5y ago
I do this when renting apartments. Rules like no pets, no additional occupants, etc are unenforceable where I live. But if I asked the landlord to change it, they may just pick someone else. Therefore, I sign and break the contract.
765.
by srcreigh 5y ago
It was probably considered a re-post if there was no significant new information. Other HN users flag. If you think it was flagged in error you can email HN.
766.
by srcreigh 5y ago
Triangles are super easy to draw (ie see) and the math is usually very simple. If there's an associated formula, working with formula is also very possible without visual skills. Trickier problems involving several shapes like a puzzle
767.
by srcreigh 5y ago
Not much for exactly this reason. Some fiction is more poetic and dialogue-y or emotional so it's fine. I loved Zen and the art of motorcycle maintenance. I never understood the descriptions of environment or anything. I'm just re
768.
by srcreigh 5y ago
Aphantastic here. I get cool star patterns after drinking booze and laying down with my eyes closed. Like fast changing animation of different aspects of the shape changing-size, color, number of points, length of points, sometimes other ty
769.
by srcreigh 5y ago
Nope. I still have trains of thought. It's just auditory, conceptual, emotional etc not visual. I do get distracted with thoughts (even ignoring other people sometimes) most likely same as you or anyone.
770.
by srcreigh 5y ago
Hello. For me it's monologue (inner dialogue) or vague/shadowy fleeting images. Or singing songs to myself. I can rarely keep an image in mind for more than a moment, and it's always mostly colorless, not detailed.
771.
by srcreigh 5y ago
How would this provide read / write isolation? Or rollback in case of failure(power outage)?
772.
by srcreigh 5y ago
For what it's worth, when I purchased a desktop PC last year, I had to return 3 before I got one which wasn't problematic. Two of one model both shut off randomly, the first of the 2nd model had a bad hard drive (write failures wh
773.
by srcreigh 5y ago
One local gym chain in my area doesn't accept credit card for monthly membership. You have to give them direct access to your bank account EDIT: Fit4Less is southern Ontario
774.
by srcreigh 5y ago
Out of curiosity, how's your visual imaginative abilities? The aphantasia test: imagine a person rolling a ball across the table. What color was the person's hair? If it didn't occur to you, you may have aphantasia. (This abi
775.
by srcreigh 5y ago
This is on my list now. Sounds similar to one of my favs, Charlie Kaufman's Adaptation, a movie about himself and his alter ego struggling to write an adaptation of a book.
776.
by srcreigh 5y ago
The thing is, nobody except this dude has actually explained the situation properly. The context of the "world of pain" is that nobody convinced everybody it's just damage control and profits and not about their ideas being b
777.
by srcreigh 5y ago
> Musk said that if he succeeds in his bid, he would seek to retain as many other shareholders as the law allows for a private company, rather than being sole owner. This really changes the equation for stakeholder value. The offer isn&#
778.
by srcreigh 5y ago
Technically projecting a thought is a different ability than reading people's minds. The trick could be supernatural but still not involve reading minds. Aka send a few messages of common names, look for cues (such as "I got it&qu
779.
by srcreigh 5y ago
has it been more than a year? How does Jimmy feel about going first on Dec 31 (day 365) and Jan 1 (day 1)?
780.
by srcreigh 5y ago
Prettier the buffer every once in a while. Tide mode can be pretty annoying with JSX. I try to be okay with temporary syntax imperfections and get in the zone with the actual changes.

More ›