-
Welcome to B4X forum!
B4X is a set of simple and powerful cross platform RAD tools:
- B4A (free) - Android development
- B4J (free) - Desktop and Server development
- B4i - iOS development
- B4R (free) - Arduino, ESP8266 and ESP32 development
pragma
-
Android Code Snippet Tip: B4a SQLite Database Potholes - WAL File Checkpoint
Hi B4X'ers I just thought I'd post this tip to warn of a problem I came across when using an sqLite data base created and populated using sqLite Studio. The steps I used were. Created an sqLite db using sqLite Studio on Win 10 pc Set the DB to use the Write Ahead Log journal method (WAL File)...- rgarnett1955
- Thread
- b4a pragma sql sqlite wal
- Replies: 0
- Forum: Code Snippets
-
Android Code Snippet Clean SQLite database, if it grows much
Long working apps have DB that grows and grows. It must be controlled, when records qty is very big, and most old data should be deleted: Sub Clean_SQL(tables() As String) As Boolean 'Starter.SQL is already open Dim TotalRecordsLimit As Int = 20000 'set yourself according to the...- peacemaker
- Thread
- pragma sqlite
- Replies: 5
- Forum: Code Snippets