Questions tagged as 'sqlite'

1
answer

Cryptography in sqlite

I need to save some data in SQLite, but this data needs to be encrypted, and, when the user needs it, decrypted. What is the best way to do this?     
asked by 08.03.2017 / 17:52
2
answers

Mobile Database

I'm creating a mobile application and I need to use a database to save user data. I have already thought about SQLite, but it is not recommended to use it on sites with more than 100,000 requests per day, and if my application has this number of...
asked by 15.11.2016 / 05:15
1
answer

Size occupied on disk by a table in SQLite

In Oracle, when we want to know how much a table occupies disk we can query the dba_segments dictionary. SELECT segment_name, segment_type, bytes/1024/1024 MB FROM dba_segments WHERE segment_type='TABLE' and segment_name='<nome-tabel...
asked by 10.06.2016 / 20:40
1
answer

Embedded database with C # [closed]

I'm developing a local desktop application. As there will be no database servers, I have studied some, such as Firebird, SQLite, Access and even Localdb. But I still feel "lost" in which to work. I know the general choice is SQLite, but I did no...
asked by 06.11.2015 / 13:45
1
answer

How to do a "for each" in SQLite

I have a table A with n records. For each record in this table, I want to get the information from a x field to make a select and, from the result data of this select , make a insert on a table B. Only that I need to do t...
asked by 12.06.2018 / 20:34
1
answer

SQLite being accessed remotely

Would it be possible to create an App connection on Android with the SQLite service with Local PC? I do not speak of a database within the own Android, but rather communicating with PC itself.     
asked by 04.09.2016 / 14:16
3
answers

How to erase database data in android studio?

I have an application where the user logs in the first time, I save Token and NIU , so the next time he accesses the application, he already goes directly to Webview using this token e NIU who are in the bank. However,...
asked by 21.02.2017 / 14:00
1
answer

Xamarin - DependencyService NULL

Dear, good morning! I started to see a tutorial to develop a simple app in Xamarin with SQLite, but I'm having a problem with an object that calls DependencyService, it is always null, and I can not find the solution. The following is the...
asked by 02.05.2016 / 16:44
1
answer

How to get the path to my SQLite database?

I need my app to back up and restore the data that is written to SQLite. I followed some internet tutorials but I am not able to copy the data! String packageName = contexto.getPackageName(); String NOME_BD = "estudos_sql.bd"; String BD_FILEPA...
asked by 05.06.2015 / 12:17
2
answers

How to return strings that are in ascending date format in SQLite?

I've taken a long and recorded in the database with this format SimpleDateFormat("dd/MM/yyyy") which is a string and now I need to organize the dates. I tried to use this command but it comes in descending order ORDER BY date (data_c...
asked by 05.10.2015 / 17:14