current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers

Tagged Questions

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

learn more… | top users | synonyms (2)

-1
votes
1answer
8 views

ADD COLUMN WITH LOOP - sqlite python

I make a database (using sqlite3) for a scientific program (Python). This program build makes loops which gradually build the database. So the problem is to add column with a loop. I made an example. ...
0
votes
0answers
11 views

In-Memory Database for ASP.NET mvc4

I am very much new to MVC4 ASP.NET and In-memory databases. I apologize if my answer is too basic and stupid. I want to create an ASP.net MVC application that uses in-memory DB(SQLite3)by using ...
0
votes
2answers
37 views

Efficient persistent storage for lists in Python

I have a (key, value) map where for each key I have a somewhat large list of heterogeneous lists (~max about 250 items). Each list is a mix of strings and numbers that I might want to iterate over. ...
1
vote
3answers
22 views

how to update or delet from database

I am new to database i just created a simple database .please let me know how to delete a single row from this data base and how to edit a single row from this database :) thanks in advance ...
0
votes
1answer
9 views

SQlite WAL-mode in python. Concurrency with one writer and one reader

I'm trying to share a sqlite3 database between one writer process, and one reader process. However, it does not work, and it seems to me that nothing is being written in example.db. reader.py import ...
-3
votes
0answers
14 views

how to read and write SQLite database file in java (after making jar file)

I want to create a java application which will use Sq Lite database and after making jar file my application will read and write Sq lite database file. So how to achieve this.... please give me ...
0
votes
0answers
10 views

synchronizing remote database and sqlite database using long polling in a angularjs application

What is a efficient way to synchronize a remote database with a local database on a mobile device (in this case a sqlite database) using angularjs long polling mechanisms? The main requirement is ...
-1
votes
1answer
12 views

Column not found in SQLite databse

I reated a column name called _id, but when I run and view the database in a ListView by using the getAllRows() method, it shows an error saying (no such column: _id (code 1): , while compiling: ...
0
votes
1answer
15 views

Android programming storage options

I have some data in android which I just want to display in list view. and the data have categories which have A to Z options. which data storage option should I use because the category have many ...
0
votes
3answers
13 views

SQLite: Count the number of similar COUNT(*) rows resulting from a GROUP_BY statement

I'm not very good at SQL, and I have a very peculiar request to do. My table looks something like this : FOO BAR ----+---- foo1 bar1 foo2 bar3 foo1 bar1 foo1 bar1 foo2 bar3 foo4 bar3 foo3 bar2 ...
-2
votes
0answers
14 views

Android Cyanogen Trebuchet launcher

I'm trying to modify launcher.db file in trebuchet configuration (/data/data/com.cyanogenmod.trebuchet/databases/launcher.db) in my app. But when I ask to trebuchet to reload it is always broken and I ...
1
vote
1answer
17 views

Sqlite Get counts of all distinct values across a row

For a personal end of the year project I've scraped my attendance off the school website hoping to do some form of visualization of the data. I've now gotten stuck transforming that data into the form ...
0
votes
1answer
20 views

ActiveRecord query to join Posts, post authors and likes in Rails 4

So, I have read through quite a few rails active records pages, stack O questions and answers (about 12 hours of time) trying to figure out how the heck to tie all of these things together into a ...
0
votes
0answers
9 views

Can't uninstall Ditto application, need help to uninstall [on hold]

I am trying to uninstall the latest version of Ditto which is a Clipboard Manager but I get the following error message. internal error cannot find utcompiledcode record for this version of the ...
1
vote
1answer
17 views

iOS 8 - Share Documents Directory Between Apps

My team is developing a suite of in-house apps for a large organization, and each of these apps needs access to the same data. This includes large amounts of user data and ~50MB of other data that ...
0
votes
1answer
13 views

Issue with sending nested json objects to sqlite db

I have a large file of json objects that is one object per line. I would like to send this data to a sqlite database. Each json object is formatted like this: {"1": {"google": 5}, "2": "", "3": ...
0
votes
1answer
29 views

Require guidance over sql table architecture

I'm fairly new to SQL and I'm having a hard time coming up with a good plan for tables etc to my problem. I'm attempting to create a program that makes use of Sqlite to make it easier for myself to ...
0
votes
0answers
14 views

Importing existing sqlite db into Swift project

I have not developed anything for IOS in a long time so please bear with me. Using the Swift language for the first time in XCode 6.3. I have a pre-existing sqlite database, myDB.sqlite, that I want ...
1
vote
1answer
21 views

sqlite self join with where clause

I have a table that consists of names, points, and years. I need a command to return all the names for a specific year even if the name isn't included in that year. Example Name Points ...
0
votes
0answers
15 views

Check if Query in sqlite is empty in a bindView method

Please is it possible to check if data queried from android sqlite database is empty in a bindView method? If yes kindly direct me on that. This is what I have done so far, but I think I am doing the ...
1
vote
0answers
26 views

how to use Java.sql.* package in android app? [on hold]

i am writing an android app that will use SQLite database. some of my packages were written in a Java project and not in android application project. I want to write my DataBase class helper as Java ...
0
votes
1answer
20 views

Sync user data in Android with Google Drive

I have a standalone android app that stores user data in the device. I have this idea to sync the database file with user's google drive account. In this way user can access the same data from ...
0
votes
0answers
8 views

SQLite 2.8 Source for Windows

I am searching for SQLite 2.8 Source Code for Windows. I need the whole package, with Makefiles etc. What I have found are links like that: ...
0
votes
0answers
14 views

How can I connect to a SQLite data source using JDBC on Debian/ARM?

I'm attempting to port a small Java application to a Debian Linux environment running on an ARM processor (specifically, a Freescale i.MX28 CPU with an ARM926EJ-S core). The application persists ...
0
votes
1answer
30 views

Android-Not able to write to database

I am having issue with android app connectivity to SQLite database. I have an instance of SQLite database in Assets folder. 'Select' operation returns the data that is manually inserted into ...
0
votes
1answer
24 views

App not saving or displaying data correctly

My app is supposed to save data in a database then display it in a listView. Problem is that the listView doesn't display anything. Looking through the error log it seems to say that it has problem ...
0
votes
1answer
11 views

sqlite get current date as integer yyyyMMdd

is there any way to get the current date as an integer, in format yyyyMMdd ? Already tried : select date ('now') But the result is 2015-06-12 Thanks!
1
vote
0answers
7 views

How to download sqlite DB from server and use it in uitableview?

I have a download DB button to download a sqlite 3 database from server. When I click on it, the output can show "File Saved !" But when I try to access the DB, it shows "no such table". Can anyone ...
1
vote
1answer
63 views

How to read 4 Millions lines from SQLite and write them to a file fast?

In my current android project I am developing an application, that records communication data. Each data packet is stored in a single row inside my SQLite database. One of my test recordings has ...
0
votes
2answers
21 views

C# - SQLite SELECT Query * Return Data Type

When I query a SQLite Table from C# using an asterisks like: string SQLText = "SELECT * FROM [TableName]"; SqliteCommand Command = new SqliteCommand (SQLText, Database); (?) Result = ...
0
votes
1answer
19 views

sqlite add x days to date (x stored in table)

I need to do something like this in sqlite (c# app): select DATE(XDATE,'+XDAYS day') from TABLE XDATE and XDAYS fields are strings type, stored in "TABLE" table. someone understood me and could ...
2
votes
1answer
17 views

SQLITE3 UPDATE CASE Node.js

I'm using the sqllite3 npm for node.js and I want to do the following: A player can play the game 10 times. 24 Hours later the counter resets and he can play 10 games again. My thought was doing it ...
-3
votes
0answers
26 views

How this “effect/view” is called?

I'd like to do something simmilar to it: https://www.youtube.com/watch?v=ch5U-bO5trg And the first question is: What is the name of this view?? And the second question is : Question its 2015, ...
-7
votes
2answers
49 views

Get value from SQLite database:

I'm a very unexperienced programmer, so please forgive me, but i have searched the web far and wide, and come up with nothing. I have a java program in which i use a SQLite database. I simply need to ...
1
vote
1answer
33 views

Create anonymous type list by running sql query in Sqllite database for windows phone

I have to run a sql query in sqllite db and get anonymous result back. I have written the below code. var userlist = new List < user_tbl > (); var userlogin = new List < ...
2
votes
2answers
29 views

How to validate registration data and insert it into SQLite Database?

I can insert registration data successfully. But I want to validate register form. So, I do validation code. The validation code is ok, no errors. But I can't relate between insert data code and ...
-2
votes
2answers
29 views

SQLite bug in WHERE clause [duplicate]

Can anyone confirm that this is a bug? CREATE TABLE meta meta_id INTEGER PRIMARY KEY, localAbsPathAndName TEXT, purgeGUID TEXT ); INSERT INTO meta (localAbsPathAndName) VALUES ...
0
votes
0answers
21 views

Querying relational data from ContentProvider

I'm having trouble creating a query request that allows me to retreive an object from multiple tables. The goal of the data flow is to have a request call 'insert' or 'update' on the ...
1
vote
1answer
42 views

xamarin android ListView with image

Im tring to load data from database and display on a ListView. The list view contains 2 textview and 1 image view. Im using SQlite.net. Where is my databse: Database public class contacts { ...
-1
votes
0answers
15 views

How to select empty columns and Assign to String in Android SQLite?

I have a SQLite database in my Android App. Which has few empty columns because i have to insert them later. My table after initial insertion look like this. Now i have to update them later. It ...
0
votes
1answer
15 views

Python SQLlite3 loop to find row with fetchone

I have a snippet in my code that needs to find a mac address in the database, then print a statement to show what row it's been found in. I will then use that row number to update the timestamp column ...
0
votes
1answer
53 views

SQLite doesnt create table

Can you tell me what I did wrong? I have allready developed some apps for android using sqlite without any errors. Whereas I do this by looking at the code in the previous project. I also tried this ...
0
votes
1answer
32 views

Android: Making application wait before executing task (AsyncTask usage)

Hello I will define my problem more clearly here. I am working on my first Android App that reads simply an NFC Tag and compares it to an SQLite database stored on the device. In short, if this is ...
0
votes
1answer
34 views

Getting order by given order android SQlite

I have an book mark option in my application, here to sort in SQLITE by "order by" using selected set of column values (ID) like: order by (ID=1,5,4,3) so I would get record 1, 5, 4, 3 in that order ...
0
votes
2answers
26 views

Android - Checking value from an SQLite DB table

I'm trying to read data from newly deleted SQLite db table row. Basically my program will delete a row when a certain activity is loaded, and I want to check the value inside the row. This is my get ...
0
votes
0answers
15 views

Implementing sequelize ExpressJS

I am implementing sequelizer in an sailsJS application (ExpressJs), I am following this tutorial: https://github.com/sequelize/express-example from the sequelize team that explain how to implement ...
0
votes
1answer
22 views

Sqlite PHP permission issue / writing to a different folder

I have two sites running off a single box that answers on different ip addresses. Both of these sites have different root folders /var/www/ and /var/www2. /var/www contains the main site and a ...
3
votes
1answer
69 views

How to download file from Google Drive using Drive.API?

I am using Google Drive.Api in order to get user's app data synced with users drive account. The user database is in sqlite database format. I have successfully uploaded the file in binary to the ...
0
votes
3answers
25 views

Returning an int from a single row in a Sqlite DB

I need to return 2 ints that are from a DB, but, I can't seem to get the query right. $result1 = $db->query('SELECT * FROM StoredData WHERE VoteName="foo"')->fetch(); $result2 = ...
-2
votes
0answers
9 views

Where to find SQLite3 for windows 64bit? Couldn't find it on SQLite website

Searched a lot. Couldn't find SQLite for windows 64 bit. I want to use it in ruby application.

1 2 3 4 5 … 797