Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how can I change PRAGMA settings in sqlite?

Tags:

sqlite

I need to change the pragma options to this. How should I do it? Where do i need to use this command? And how do i use it?

PRAGMA default_synchronous = OFF;

like image 823
Petah Avatar asked Dec 10 '25 09:12

Petah


1 Answers

PRAGMA is an SQL command. Just execute it like you would do with any other command, such as INSERT.

(Please note that SQLite simply ignores unknown PRAGMAs; the statement you've shown will have no effect.)

like image 96
CL. Avatar answered Dec 12 '25 05:12

CL.



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!