Why can't sqlite3 be used in creating large databases | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 7

Why can't sqlite3 be used in creating large databases

4th Dec 2020, 11:34 AM
Pythøñ Cúltîst⚔️🔥🇳🇬
Pythøñ  Cúltîst⚔️🔥🇳🇬 - avatar
5 Answers
+ 10
Êskåy🔥🔥 When used with the maximum page size of 65536 this gives a maximum SQLite database size of about 281 terabytes. The max_page_count PRAGMA can be used to raise or lower this limit at run-time. it can make some small database till the limit but you are in the need of creating large databases ig... I will recommend you to use varchar.. maximum size of a VARCHAR in SQLite.. You can declare a VARCHAR 10 and SQLite will be happy to store a 500million character string there. And it will keep all 500million characters intact. Hope helps
4th Dec 2020, 2:52 PM
+ 6
Maximum sqlite3 database size is 281 terabytes that is also big size You know all lite version is smaller in size & giving smaller performance than real version
4th Dec 2020, 11:41 AM
Sâñtôsh - avatar
+ 4
281TB should be enough for most individuals. If your application one day becomes as big and successful as facebook, you can change the database.
4th Dec 2020, 8:13 PM
Sonic - avatar
+ 2
Maybe because it is the lite version of sql and that's why it doesn't use for large databases.
4th Dec 2020, 11:39 AM
The future is now thanks to science
The future is now thanks to science - avatar
I think 281 terabytes is enough for mini project but that depends on what you called a large database though
6th Dec 2020, 9:38 AM
George S Mulbah II
George S Mulbah II - avatar