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

learn more…| top users | synonyms (2)

0
votes
0answers
4 views

How can I prevent sqlite from creating multiple database entries in Node

I have 2 functions that I am using to access different columns in a single database based on a user ID. If the ID does not have a row in the database, I create a new row for that ID in the database. ...
1
vote
0answers
9 views

sqlite JDBC metadata.getPrimaryKeys return info of foreign keys

sqlite JDBC metadata.getPrimaryKeys return info of foreign keys. e.g.,create table Foo (id integer, bar_id integer, primary key(id), foreign key (bar_id) references Bar(id))JDBC:...
0
votes
0answers
11 views

Insert row at a specific ID Room Android

I am trying to insert a row at a specific ID using Android's SQLite wrapper, Room. Basically, the use case is I get a row of data from a server and I want to use the remote row's ID as the primary ...
0
votes
3answers
24 views

sqlite android Update with punctation

I have a problem with a querythis is my sqllite tableCREATE_CONFIG_TABLE="CREATE TABLE " + TABLE_Config + "("+ KEY_ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"+ ...
-1
votes
0answers
26 views

Regular expression search through three columns using python for SQLite

I am looking for a regular expression that can search through each group and find the number that I input in the recompile command. My regular expression is going through each line, but it stops at ...
0
votes
1answer
10 views

Subqueries with SQLite and JSON1

I have just discovered JSON1 for SQLite and find that it would be the perfect answer to many of the issues I need to deal with in my Android app (I am using SQLCipher which offers a version of SQLite ...
-1
votes
2answers
31 views

SQLite take N rows per each group

I have an SQLite table similar to the following:| A | B |_________| e | 5 || f | 7 || a | 5 || n | 7 || g | 5 || d | 7 || i | 5 || j | 5 || e | 7 || v | 7 |How can I retrieve three ...
-1
votes
0answers
11 views

SugarORM Error ( Code 1) no such table

I use SugarOrm in my android project.When I save entity (Customer customer=new Customer) with customer.save() method, I get the exception as no such a table error code=1.Why am I getting this ...
-2
votes
0answers
20 views

How can I release resources in my application, with internal Sqlite base which slows down my cell phone? [on hold]

I have a Xamarin Forms App with Sqlite that slows down my cell phone after inserting data, how do I free resources so that my cell phone does not slow down?
0
votes
0answers
17 views

SQLite substring search query doesn't work

I am trying to do a substring search.. and I am trying to ignore the upper/lower case.. but it does not work.. the databse returns nothing. But when removing the "%" and the last parameter -sort ...
1
vote
0answers
22 views

How to use the latest sqlite3 version in python

I need to use sqlite version 3.8 or higher with python in Amazon Linux. I updated my sqlite installation to the latest version:$ sqlite3 -version3.22.0 2018-01-22 18:45:57 ...
-2
votes
0answers
19 views

How to Establish Communication between Fragment's Adapter and New Fragment?

FragmentsI had created Tabbed Activity with two tabs.Fragment 1Fragment 1 saves data to sqlite database Fragment 2Retrieves all data and shows in recycler view Problem: When the user clicks ...
0
votes
0answers
34 views

Why doesn't my Java code create a table in an in-memory SQLite database and print the table name?

I want to create an in-memory database and check that the table exists afterwards. Unfortunately, my code doesn't print anything to the console, so either the check for a table or the table creation ...
1
vote
1answer
36 views

Common column between two tables

I am writing an android app that has two tables:String createQuery1="CREATE TABLE " + TABLE_NAME_TRIP + " (" + IDTRIP_COLUMN + " INTEGER PRIMARY KEY, "...
0
votes
1answer
16 views

cur.fetchone()[0] not subscriptable (or) local variable referenced before assignment

I've got some problems with Sqlite, trying to take a link from an SQL table[1] i used two methods ( that both failed ):the first is showing : 'NoneType' object is not subscriptable for k in ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,