Questions tagged as 'sqlite3'

Tagged questions
1
answer

Working with high-quality images in sqlite3

In my application I make the selection of an image of the gallery, then I save it in the bank, but if the image has a high quality the app does not save, besides saving it stops working, has some way of save that image in the bank even if it is...
asked by 19.10.2016 / 20:22
1
answer

Encrypt SQLite3

Is there a free way to encrypt SQLite3 database? I've seen some very expensive proprietary software.     
asked by 12.02.2016 / 14:21
1
answer

SQLiteStudio data types

I'm using SQLiteStudio to model a database. At the time of creating the fields of a table, I noticed that it has some data types that do not appear in the SQLite documentation. For example, in the combobox where we chose the column type, it has:...
asked by 07.02.2016 / 18:28
2
answers

How to check if there is any sqlite database in the application?

I have the following dilemma: I am putting together an app where I perform a synchronization between a MySqle database and SQLite using a Webservice. My database is already available in MySql, and in my app during my splash screen I need t...
asked by 09.01.2016 / 21:57
1
answer

Error: Undefined reference to 'sqlite3_open'

I am creating a software in C that uses SQLite 3 as a database, but when compiling the project Codeblocks returns me the following error message:    createdata.c || undefined reference to 'sqlite3_open' |       undefined reference to 'sqlite...
asked by 26.10.2015 / 23:18
1
answer

Keep alive object in memory for another class

Hello! I have a very simple question, as I have already found a solution for her, but it still seems problematic to me. I'll explain: I created a web service connection to receive some data, and in the end I am storing this data in a dictiona...
asked by 15.07.2014 / 18:00
1
answer

Exception when searching the SQLite database

12-10 09:25:36.029: D/dalvikvm(21543): VFY: replacing opcode 0x6e at 0x0002 12-10 09:25:36.279: I/Adreno-EGL(21543): <qeglDrvAPI_eglInitialize:410>: EGL 1.4 QUALCOMM build: () 12-10 09:25:36.279: I/Adreno-EGL(21543): OpenGL ES Shader Compi...
asked by 10.12.2014 / 18:32
1
answer

How to count the number of rows in a table in python

Example, I have a database called 123, in this database has the players table, which would be where the players' accounts are. I want to count how many accounts there are in the database. Finally, count the number of rows in a SQLITE3 table,...
asked by 12.10.2017 / 03:27
1
answer

How to return data from a select in sqlite3 as dictionaries instead of tuples in Python?

I'm using sqlite3 to write some data. However, by default, when a select is made, it returns the information as a list of tuples, which is considerably more difficult to work than if they were dictionaries. Example: >>> import sqlite3...
asked by 28.10.2016 / 13:16
1
answer

Error collecting value from va_list in C

Good afternoon. I encountered a problem when preparing va_list in c. of two similar codes, one works and the other persists in error. extern bool _sqlite3_insert(const char *table, const char *types, ...){ M_HEADER; // macro com as...
asked by 19.02.2016 / 20:57