I don't think you can round the database, at least using sqlite command line example: create a table with two numbers > sqlite3 myroundingtable.db SQLite version 3.29.0 2019-07-10 17:32:03 Enter ".help" for usage hints. sqlite> create table mypar (one, second); insert two rounded numbers sqlite> insert into mypar VALUES (round("30.1233198123987303101203",1), round("30.817232123312")); query them, ok seems to be rounded sqlite> select * from mypar; 30.1|31.0 sqlite> .q but, then dumping > sqlite3 myroundingtable.db ".dump" PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE mypar (one, second); INSERT INTO mypar VALUES(30.10000000000000142,30.999999999999999999); COMMIT; So, we asked sqlite to round and store two numbers, it says yes I do but it doesn't. I am not asking for any fix, only pointing that it is an issue