What to choose to store just one whole? SQLite? or text file?

Question

I created a small web service in PHP. I want to control the number of calls for a specific API method.

At first I thought about using a text file because it is just an integer. But looking at SQLite, it looked much more convenient. Thus, the code is simple: get the "counter" from SQLite and increase it when you call this method, and then save it to SQLite db.

Is this the right way to do this? Would it be easier and more scalable to use the file or ... maybe something else?

Thanks in advance.

Answer 1

, SQLite DB , , , . , ​​ MySQL, MSSQL .

Answer 2

: memcachedb. memcached, BDB. , / .

- "-". , "" "" . , "" . concurrency, .

C. , , . , .

Answer 3

, , .

Answer 4

, .

• "".
• , SQLite ( SQL, )
• SQLite (SQLite - )

- - , , -. , ... SQL .

Answer 5

, , .

Answer 6

SQLite, , "100K [sic] hits/day". , , ​​ MySQL. 100 . -, , - , , . . PHP, .

, SQLite: " fopen(), fread() fwrite() . SQLite ad hoc." ()