Questions tagged [sqlite]

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

0
votes
0answers
12 views

How to make models in django which have different models as table columns which are specified upon different conditions?

I am new to django development and am stuck in a project that I am working on.I have been trying to create a website where multiple people can rent different furniture items for their houses, for a ...
0
votes
1answer
19 views

optimising sql queries on tables without rowid or primary key

I have a db that has a table which does not have a rowid or a primary key. It simply has two columns timestamp and value. both values are double. timestamp is sorted in ascending order.Is there a ...
0
votes
1answer
16 views

I am trying to delete a record from my table but I get an 'incorrect bindings supplied error'

Here is my code:def delWorker():deleteWorker=input('Please type in the surname of the worker you would like to delete. ')c.execute("DELETE FROM employees WHERE lastName=(?)",...
-1
votes
1answer
42 views

What is the best way for storage something in Ionic? [on hold]

I have a login service. And i have to store userCustomerId and userName when user logged in. Because i'm using these datas on another pages (cart, accountInfo etc.). Should i use SQLite? Actually i ...
-1
votes
0answers
37 views

Showing several sentences for a given category in a SQLite database

I am developing an app quote and I am using a local database to import the quotes.I have an issue here as you can see in the picture I want to put multiple quotes in one title.For example, The ...
-2
votes
0answers
31 views

How to get Next increment id in Room Database?

I am using Room Database for my chat app and I want to know how to get Next increment id of my primary key.In sqlite i know about it but in Room Database how to get that id, like in sqlite Max id ...
0
votes
0answers
22 views

Parsing MySql long datatype containing datetime To C# DateTime

I am in process of developing Android Application which has local database in SQL Lite where storing date / time as long datatype in database.Android Application synchronize the data using Rest API ...
0
votes
0answers
10 views

SQLite Insert blob with AngularJS and cordova

Basically I need to insert some data inside an MBTiles. MBTiles uses sqlite to save also tiles (in my case are PNG images saved as blob). I can retrieve the blob in BASE64 and see it but as I need ...
0
votes
1answer
10 views

Entity Framework Core: related data missing for every other result with SQLite

I have an odd issue when retrieving data from the database. This is a project that is being upgraded from .NET Core 1.0 towards .NET Core 2.1. Everything was working beforehand, but the upgrade has ...
0
votes
1answer
40 views

App crashes loading database at the first run

In my app, I'm using a service to get data from JSON and then save it in the database.when I run the app on a new device it crashes without any error!But when I comment out the code that is for ...
1
vote
1answer
33 views

SQLite Dynamic where-clause for ToggleButtons

I would like to create something like a dynamic where clause but struggle with it.FrameWork:I want to use 4 Togglebuttons, which obviously return me with "Togglebutton.ischecked()" a true or false ...
0
votes
1answer
40 views

SQL for how to Get next stations based on station_id in GTFS data

This is my SQL querySELECT Routes.route_id, Routes.route_desc, Routes.route_type, Trips.service_id, Trips.trip_id, Trips.route_direction, Stop_times.stop_id, Stop_times.arrival_time, Stop_times....
0
votes
1answer
19 views

Sqlite3 error message is shown on Postgresql application

I am learning to build an app using node express and knexjs to connect to the Postgresql database. When I do a post request, this warning message shows up. The data that I try to post is not in the ...
-2
votes
0answers
31 views

How do I access the last record in the table? [on hold]

I have a table in the database called Measurements.The temperature of the place is recorded every minute.How do I access the last record in the table?
1
vote
2answers
38 views

Sqlite query comparison multiple times

I have the following schemas (sqlite):JournalArticle(articleID, title, journal, volume, year, month)ConferenceArticle(articleID, title, conference, year, location)Person(name, affiliation)Author(...

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