The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
6 views

Syncing structured data and files in Android App with an ORM?

I am developing an Android App which I have developed for iOS before. The app requires that structured data and files are synced across android devices. In iOS, I was using Core Data and synced to ...
-3
votes
0answers
11 views

how to display database with javascript in the form of a table? [migrated]

I have problems with my application that is when it will display the data from the database in the form of a data table that happen to two sideways instead of down main.js ...
0
votes
2answers
41 views

Representing category splits in a personal finance database

I'm working on developing a personal finance applications (e.g. Quicken/Mint.com/etc..). I plan to store the data in a SQLite database. I'm stuck trying to determine how I want to represent splits in ...
0
votes
0answers
68 views

Custom Sync process and how to prevent SQL injection

I have a custom sync process where I need to ensure that there's no possibility of SQL injection. For background, the device stores records in a Sqlite database, whereas our central server is Sql ...
-3
votes
1answer
174 views

Sqlite3 slow on standard queries, is it expected? [closed]

Using Python and sqlite3. This simple print loop takes a few seconds to execute. I don't know much about databases, so I'm guessing I'm not using these queries correctly. Surely sqlite should be ...
0
votes
1answer
354 views

What is the traditional way to maintain extensibility in a database-driven application like this?

I'm working on a simple application for a game in Java that allows a user to record whether they have collected a given item and how much experience it contains. This will work for multiple item types ...
0
votes
1answer
369 views

sqlite trigger or application event?

I've have two event queues(table mapped queues) based on two different states of same data stored in two different tables. The events are generated on create/update/delete on both the tables. ...
1
vote
1answer
114 views

Why chaining matters (Python & SQLite3)?

Why does cursor = connection.cursor() cursor.execute("... return cursor.fetchall() return the expected non-empty result whereas connection.cursor().execute("... return ...
15
votes
4answers
10k views

Why is Web SQL database deprecated?

I am making a hybrid Android app. At first I decided to use localStorage, after spending 2 days, I realized that it is very strange and so dropped it. Then, I picked up indexedDB, after spending ...
22
votes
2answers
1k views

Internal-use websites: Is there a compelling case against SQLite?

Many web frameworks, such as Flask or Django use SQLite as their default database. SQLite is compelling because it's included in python, and administrative overhead is pretty low. However, most high ...
5
votes
1answer
262 views

Can anyone explain to me what problem Core Data solves? [closed]

Core Data seems to add a needless layer of complexity. If you want to save data created natively by the user in an app why not just use an object and then write the data all to SQLite or back to a ...
0
votes
1answer
141 views

How should I evaluate the Database Solution for Large Data Application

Background I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
1
vote
1answer
293 views

In Android, is there any reason to set up a content provider for a local database?

I have an android application with a custom content provider set up to load data asychonously. The database is a local file so I'm not sure if I needed to set up a content provider at all. Sometimes I ...
12
votes
2answers
2k views

SQLite with two python processes accessing it: one reading, one writing

I'm developing a small system with two components: one polls data from an internet resource and translates it into sql data to persist it locally; the second one reads that sql data from the local ...
1
vote
1answer
3k views

External sqlite db file from sdcard in android

I just searched for the same but didn't get the answers. What I have is a db file which is around 100MB. I have saved the db file in sdcard . Through this db file I'm going to populate the contents ...
1
vote
1answer
121 views

A way to include SQlite into an application where the drivers aren't already installed on the system?

I'm an open source web application for use in my university. Currently professors usually have a website, but do to the fact that they're teaching multiple classes in a given term, they don't care to ...
0
votes
2answers
3k views

Drop table if it already exists and then re-create it?

I was just learning about sqlite in android programming from the New Boston Travis videos and I have come across something strange: It is said that if the database does not already exists, onCreate() ...
2
votes
1answer
124 views

Handling Dynamic amount of Strings for persistent and runtime storage in an IOS App

Background I am dynamically building an FQL query statement and because of the nature of the app, I exclude FB family members, this is the base portion of the query and remains fairly static. The ...
0
votes
1answer
2k views

Sync SQLite using only HTTP

I currently have a SQLite DB on my server that is needed by an android app I am currently developing. I download the DB to the android device using HTTP each time the contents are changed. Does ...
1
vote
0answers
123 views

What will be the better way for data retrieval on application that needs to handle limited amount of data? [duplicate]

Just moved this question from Stack Overflow. Since, adding my code snippets itself would make this question really long. Instead, I am pretty interested in knowing a better ways for data retrieval on ...
7
votes
1answer
2k views

Why do Core Data sqlite table columns start with 'Z'?

I was looking at the sqlite table that Core Data generates and noticed that all table columns start with 'Z'. I realize this is an implementation detail, but I was curious as to why that's the case ...
0
votes
2answers
865 views

Android Card Game Database for Deck Building

I am making a card game for Android where a player can choose from a selection of cards to build a deck that would contain around 60 cards. Currently, I have the entire database of cards created that ...
1
vote
1answer
861 views

How to store data in Gujarati language in SQLite?

I am developing an Android application for Gujarat's farmers. So this app should be in Gujarati also. Is there any way so that I can store my data in Gujarati in SQLite?
2
votes
1answer
210 views

How to run thread if multiple data is insert in the multiple table

I'm facing problem in gsoap , if two user go to register at a same time then database is locked, i think its threading problem , how to handle it, please insist me. I am running multiple ...
1
vote
0answers
16 views

Database lock on gSoap server during storing data in table [duplicate]

Possible Duplicate: How to run thread if multiple data is insert in the multiple table I am getting the values from the android app & storing onto the server using sqlite. first time ...
2
votes
1answer
198 views

Database structure for various items

I'm building a sqlite database for an android app which will hold a list of items, each of which have different characteristics. Some of the characteristics are available for all objects, some are ...