Visual Studio Magazine

SQLite Performance and Prepared Statements

In my last column, I introduced SQLite, an amazing little database engine written and provided entirely in C source code. I showed you how to begin wrapping it up in modern C++, producing a correct ...
Visual Studio Magazine

Using SQLite with Modern C++

Microsoft has long offered a compact alternative to the mainstream editions of SQL Server, but the SQL Server Compact Edition appears to be losing steam. It's not particularly compact and has lost ...
Linux Journal

Accessing SQLite in C

In my last article I wrote about accessing a PostgreSQL database in C/C++. In this article, I'm going to discuss performing the same functions in C against an SQLite database. Unlike Postgresql and ...
知乎 on MSN

SQLite不能支持高并发，为什么又说它能支持10万的日访问量?

10万……日访问？ 那算个鸟蛋啊。 1小时是3600秒，10个小时36000秒；平均每秒不到3个访问——这点压力10块钱的esp32都撑得住，有什么玩意儿能拉胯到连每秒3个访问都扛不住的？ 哦，不对，是24小时10万访问……那每秒访问量还得除以2.4 ...