I have a system that builds SQLite databases and uploads them to S3. Once they're in S3, they are never changed. The program that builds the databases only does writes, and the program that queries the databases only does reads. It uses a VFS to query the database in-place with HTTP range requests.
This is indeed not an optimal setup. A more careful design from first principles would not require seeking around the file as much as SQLite does, we'd do a better job on reading exactly the correct range of bytes for a given query since we know ahead of time what the access patterns are, and we could do reads in parallel. With SQLite we have to be very careful about the schema design to ensure it won't have to seek too many times to answer a query. But SQLite was expedient, and I'm confident I'll always be able to read the files. That's less certain for a custom file format.
For this use case we need the ability to do an indexed query and extract a small number of rows from a large database. It's a traditional row-oriented database workload. I'm sure other solutions would also work, but SQLite's design melds well with the data. The migration from partitioned SQL Server tables to a collection of SQLite database files was straightforward.
If it's that small, why not compile it directly into the application? The compiler might even be able to optimize a good chunk of data away, or optimize the code based on the data.
Nothing small about it. This is terabytes of data and new files are added daily with new data. That's why we had to move it into S3. It was costing too much to store in SQL Server.
I only reach for SQLite when it's big. Otherwise, I'd prefer to just use the existing SQL Server infrastructure, or .csv.gz files in S3. Internally, I use the term "bulk data" for data sets that are stored in S3 because they were too big for SQL Server.
In South Africa, health insurance is prohibitively expensive, but you can get funeral insurance as a value added service from your data plan provider, bank, or even your favourite football team. It is extremely common, so there’s just more money going around. That said all the other points made around the kinship society are still valid. Its also very like that they contribute to the proliferation of funeral insurance themselves.
Thank you.
The LLMS are provided with the rules and output format and they have to write an agent (in Javascript) that will output a move at every tick. The prompt to create the initial snake and the prompt used to iterate are on the about page: https://botais.sello.dev/about.
Yeah that's good idea, thanks for the suggestion.
I even went out and bought a puzzle book while building this, so it's definitely not something most people have around.
Just FWIW, if you need a supply of sudoku puzzles, the wonderful Simon G. Tatham's (PuTTY author, for Windows users) Puzzles page has a lot of algorithmically-generated, guaranteed-solvable puzzles, including sudoku (called "Solo" on his page).
I'm partial to "Patterns" myself, though it definitely needs a mouse or trackpad (preferably the former).
Ive had the exact same issue since last week. it never fixed itself if that’s what you’re waiting for. I had to resort to creating a new account with a different email to get access again. Contacted support but yet to hear back. Not sure if it was the cause the issue happened when I try to buy Plus and that failed.
I found it was issue with Firefox and its default privacy settings. Clicking shield icon in Firefox address bar and setiting this privacy guard off made Chat working again
