Advertisement · 728 × 90

Posts by teq

scryfall.com in early 2000s web design

scryfall.com in early 2000s web design

scryfall.com looks incredible today

7 hours ago 15 3 0 0

I had a crazy dream last night

8 hours ago 12 0 1 0

Im inventing the laptop

8 hours ago 31 1 5 1

Im not that kind of bot

9 hours ago 3 0 0 0

if my name gets used for a chatbot I get paid a million dollars

9 hours ago 18 0 2 0

we are firing all the goons and replacing them with goons even more incompetent

14 hours ago 35 3 1 0

exploding bitwarden with my mind

16 hours ago 4 0 0 0

another thing neither human nor model which surpasses both

16 hours ago 2 0 0 0
Advertisement

got my boymoder ears on

18 hours ago 7 0 1 1

the checkpointing is done by the closing connection, so like if the last client process crashes, sqlite will still have wal files. but easily resumes on next connection. readers block checkpointing so even automatic checkpoints wont happen if something is locking up the wal

19 hours ago 2 0 1 0
Write-Ahead Logging

yea automatic checkpoint is at 1000 pages or when every connection is closed (if the last one exists gracefully). theres an advantage in writing records very quickly to the wal journal, and then inserting them in batch to the db. it avoids trying to do that frequently on small writes

20 hours ago 4 0 2 0

something like "pragma journal_mode" prints it if youre connected to it, usually when all connections close cleanly it should clean up the wal file but it doesnt always do that . the shm file can be ignored entirely. if a new connection finds existing wal files thats fine

20 hours ago 3 0 1 0

its when the wal gets moved into the db

20 hours ago 3 0 1 0

theyre inventing a me that is well rested

20 hours ago 40 3 3 0

you are underestimating the power of your aura . some are driven mad with jealousy

1 day ago 5 0 1 0
Advertisement

I don’t believe in space

1 day ago 17 1 0 0

me too

1 day ago 1 0 0 0

I cant believe ebvil won .......

1 day ago 4 0 0 0

embarrassing myself on a windows machine . absolutely making a fool of myself on a pc

1 day ago 55 2 3 0

how many hours do you sleep a night . like two or three

2 days ago 27 0 8 0

its so fuckin cyberpunk that your whole life can be obliterated at no fault of your own and everyone acts like youre legally dead

2 days ago 14 0 1 0

I found myself thinking this guy has a point before I realized who it was

2 days ago 7 1 1 0
Advertisement

I dont have to believe anything today

2 days ago 32 1 4 1

"computers suck—" no. your computer sucks. my computer is a beautiful perfect angel who has never done anything wrong,

2 days ago 45 7 2 0

if you post about food on this platform people go crazy . they love food

2 days ago 29 0 4 0

- mental illness
-
-
- yum

2 days ago 10 0 1 0

Im in the middle of trying to learn jj and lewis did a random cargo fmt on the feature branch to me

2 days ago 4 0 0 0

spock youre vulcan depressed again today

2 days ago 6 0 1 0

its easier to recognize brookie in these photos bc its closer to her native resolution

2 days ago 4 0 1 0
Advertisement

lets try a simpler approach

2 days ago 7 0 1 0