BLUE
Login
PostsUsersHashtags
HNmm-hacker-news.bsky.social

How to Corrupt an SQLite Database File https://sqlite.org/draft/howtocorrupt.html

0
RAbobbydigitales.bsky.social

Thi sis what I'm talking about:

At this writing, 2050 is still 34 years in the future. Nobody knows what will happen in that time, and we cannot absolutely promise that SQLite will be viable or useful that far out. But we can promise this: we plan as if we will be supporting SQLite until 2050. That long-term outlook affects our decisions in important ways.Cross-platform Code → SQLite runs on any platform with an 8-bit byte, two's complement 32-bit and 64-bit integers, and a C compiler. It is actively tested on all currently popular CPUs and operating systems. The extreme portability of the SQLite code and file format will help it remain viable on future platforms. Stable, Cross-platform Database Files → SQLite database files are bit-for-bit identical on 32-bit, 64-bit, big-endian, and little-endian platforms. You can copy an SQLite database file from one system to another without having to translate or convert the database. Furthermore, the file format is well documented and stable. Database files created today will
0
Jjoeljuca.com

Lots of knowledge in here. #sqlitewww.sqlite.org/queryplanner...

0
MRmattround.com

Yes, you can do that with existing systems, but they're all too bloated & faffy, I want something that's a folder of PHP files, an SQLite db & a folder of images

0
JQjeffquesado.ulivre.dev

Usar para bater em dois cantos, ótimo caso! Já usei pra fazer isso, consulta sql batendo no banco em litebase e em sqlite... e o bom é que a interface do litebase lembrava jdbc com índice começando em 0, portanto precisava fazer ajuste de índice para toda pstmt

0
HNhacker-news-jp.bsky.social

💡 Summary by GPT3: Cloudflareは、ストレージにSQLiteを使用するようにDurable Objectプラットフォームをアップグレードし、より高速な読み書きパフォーマンスを実現しました。各Durable Objectは、1台のマシンの1つのスレッドで実行され、異なる状態のユニットを処理するためにより多くのオブジェクトを作成することでスケーラビリティが可能です。システムは、ポイントインタイムリカバリのためにWALエントリをストリーム化し、耐久性を確保するために書き込みをレプリケートします。JavaScript APIは、 (1/2)

1
HomePopularExplore