Questions tagged as 'sqlite'

Tagged questions
2
answers

How to do a "rbind" in tables from a SQL base from R?

I would like to "merge" two tables from a SQLite database from the R - and save this into a new table within the same database. Here is a minimum reproducible code: install.packages("sqldf",dependencies=T) install.packages("RSQLite",de...
asked by 18.09.2014 / 02:27
2
answers

Can Sqlite work completely offline?

I need to save my alarms so that after the device is restarted, they are put back into operation. The problem is that I get them all through my database at mysql . What made me think that maybe it would be a good idea to save it to a...
asked by 26.06.2016 / 20:18
2
answers

Backup in SQLite database

I need to back up an SQLite Android database. Ex: I'll change the device and I need to copy the application's DB to be loaded on the other Android phone. Is there a workable solution? I developed an application that uses SQLite to write...
asked by 28.10.2014 / 15:02
1
answer

SQLite Android data insertion

What is the best way to insert more than 10000 rows of data into a table consisting of 13 columns using SQLite Android? I thought about using ContentValue then: Db.insert(DATABASE_TABLE, null, ContentValue);     
asked by 24.10.2014 / 16:21
2
answers

How to upgrade BD sqlite java android

How do I add a column in the database of my android java application without losing the data from the current database? My code: public DataBaseHandler(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } // Creatin...
asked by 31.05.2014 / 00:30
1
answer

How to mount a WebService to synchronize SQLite database of Android and MySQL

I've set up an android app that stores basic information about a contact in SQLite:
asked by 18.08.2015 / 03:16
2
answers

How to fix error "TypeError: must be unicode, not str" in Python?

When backing up my database in Sqlite3 , the Python interpreter returns the following message:    TypeError: must be unicode, not str on line f.write("%s\n" % linha) , I could not find a solution for this error. Follow the code:...
asked by 25.08.2015 / 19:30
1
answer

I can not insert data into sqlite using javascript

I'm creating a smartphone app using Cordova for a college project. the App consists of a simple register of patients. I'm having trouble writing data to the bank. Initially the recording was working, but I forgot to include an id field with a...
asked by 23.04.2014 / 17:53
1
answer

How do I save locations of a map in an SQLite database?

I want to save locations displayed on a map to a SQLite database, so that the user can refer to them in the future and can add a description. Here's my class Description ... public class Descricao { private long id; private String comentar...
asked by 02.09.2015 / 01:01
1
answer

Filter using calculated value does not work in Django

I have a template in Django with fields largura and comprimento , and I would like to filter it by area: class Projeto(models.Model): largura = models.DecimalField(decimal_places=0, max_digits=4, default=0) comprimento = m...
asked by 07.04.2016 / 15:42