Questions tagged as 'sqlite'

Tagged questions
1
answer

Numerical precision in SQLite

About numerical precision in SQLite v3.20.0. See the command sequence below and the .dump result. The value associated with the INSERT statement is not the same value as that obtained. I enter the value 123456.789 and I get 123456.7890000000043....
asked by 06.09.2017 / 21:41
2
answers

How to select a database blob and transform into bitmap?

I have the following error in my project, I select an image from the gallery I transform it into a byte in the database, but at the moment of loading it to imageView it does not appear and not from the error in the application, I'm not touching...
asked by 15.10.2016 / 00:59
1
answer

Phonegap + Cordova + sqlite

I have a problem with a misc. bank file. I created a .db file with all the columns and contents and compiled it along with the apk. The last change I made in the bank after performing a new build is giving error saying that my table does not...
asked by 10.12.2015 / 19:02
1
answer

How do I allow "bind" to "SQLiteStatement" to accept a null value in SQLite?

I decided to use SQLiteStatement because it is faster to insert data into SQLite, but at some point it may be a null value object.getAlchemistry () and in this case an error with the message that the bind is empty. Does anybody know how to solve...
asked by 10.11.2015 / 19:56
1
answer

How to use SQLite in a Cordova application?

Gentlemen, I have a hybrid application that I built in HTML, CSS and JavaScript (JQuery Mobile) using Cordova, and now I would like to access the device database. Unfortunately I do not know where to start, because in the searches I did most of...
asked by 10.06.2015 / 22:19
1
answer

How to copy SQLITE bank from internal memory to SD card Linux command

Good morning everyone, One day I was able to find the database of an android application that I'm doing in internal memory via Linux commands, the application is in Delphi XE but the storage location is the same as an application developed in Ec...
asked by 22.09.2014 / 14:24
1
answer

Delete database while uninstalling app

In my app I create the database made in SQLite in the folder:    System.Environment.SpecialFolder.Personal However on some devices (Android) when uninstalling the app it seems that the bank is still in the folder, because when you install...
asked by 24.07.2018 / 15:34
0
answers

Simultaneous threads (parallel processing) in R and serialized writing in SQLite

Hello everyone. I'm trying to develop a code that makes it possible to parser HTML files using the R language and, consecutively, write the extracted HTML data to the SQLite database in a serialized way. In order to perform parallel processin...
asked by 21.10.2018 / 21:22
0
answers

Sqlite recursive query

I'm starting with sqlite and would like help with a recursive query. I have 3 tables (generic example): CREATE TABLE IF NOT EXISTS tab_componente ( id_comp TEXT NOT NULL PRIMARY KEY, desc_comp TEXT , custo_comp INTEG...
asked by 28.04.2018 / 15:52
0
answers

Android application on local network

I'd like to know where to start studying to create an App that works on the local network. I have a version of this App that works using Firebase with my online database. I wanted to now do something similar but locally, with Wifi only Wireless...
asked by 27.03.2018 / 09:43