Questions tagged [sqlite]

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

-1
votes
0answers
5 views

Video view, Sqllite database and cannot play this video

What i have done is : recorded video from phone's camera and then taken its uri to play video. Video is playing fine. When i got uri for a particular video, i stored this uri in Sqllite database by ...
-1
votes
0answers
13 views

Python, flask, twilio and sqlite 3

i am creating a validating system with flask, python, twilio and sqlite3. anytime i enter the user password, its suppose to display the name of the user with the password and pick out the number of ...
0
votes
0answers
17 views

Anko SQLite update function isn't working on a row

My first function is create my tableprivate fun createVersionTable(db: SQLiteDatabase) {db.createTable(VersionData.TABLE_NAME, true,VersionData.COLUMN_ID to INTEGER + PRIMARY_KEY + ...
-1
votes
0answers
28 views

SQL - Compare Columns, Remove Duplicate Characters

Example table:ID RA RB------ ------ -----1 龍 龍 竜 龒2 齒 歯 齒 3 黽 黽I would like to modify column RB so that it doesn't contain any of the ...
-2
votes
0answers
18 views

What is the syntax for loading jdbc:sqlite db file from File/Byte[] object instead of path

I can load the jdbc:sqlite file as below,val df=sqlContext.read.format("jdbc").options(Map("url" -> jdbc:sqlite:<AbsoluteFilePath>","dbtable" -> "select * from your_table")).load(...
0
votes
2answers
19 views

Access result Set after closing connection with db

public ResultSet Connections() {try {conn=this.connect();stmt=conn.createStatement();// String sql="Select * from connections";String sql="SELECT ...
0
votes
1answer
23 views

retrieve the URL images from SQlite

When retrieve the images from Firebase to SQlite it comes as link, so I am trying now to show the images through Picasso as the following:Picasso.with(context).load(favoritesList.get(position)....
-2
votes
1answer
30 views

How to connect two android apps to the same database so that I can pass information between them?

I have two apps. One which is a text to speech converter. The text that is being converted to speech is stored into the database dynamically. Now, I want another app to be able to access this data. Is ...
-1
votes
0answers
15 views

SQLIte can't save records (Android SQLite CRUD and ListView)

I've been struggling to fix my codes for several days but no luck. it drive me crazy as i m a beginner in java.I created a contact list application folowing this Tutorial. I made some changes to ...
0
votes
1answer
36 views

How to select table rows in the reverse order of insertion in SQLite?

Hi i want to retrieve the rows from a table in the reverse order in which it is inserted.I know we can user integer primary key and sort with that, but since am using it an android application. It ...
0
votes
0answers
21 views

C# read excel file in datagridview and import in sqlite

I want to to import any excel file in sqlite where the sheets saves as Table name with my code i can now read the excel file and I can import table name dynamically into sqlite database but the table ...
0
votes
1answer
18 views

how to backup database in your external storage using DBFlow

how to backup application database and store in mobile storagefolder.i try to do this way but not able to create backup file.try{File data=Environment....
0
votes
1answer
18 views

SQLite query to compare dates

I have two text columns (valid_from and valid_to) in a table (history) in SQLite database in which I am storing date in dd/MM/yyyy format.Now I am running following query to fetch all the records ...
0
votes
1answer
12 views

Sqlite Discord.js: Cannot read property 'run' of null

So I am trying to make a SQLite database for my Discord.js bot, but I keep getting this error (Cannot read property of 'run' of null) when I try to use SQLite. Non of my friends seem to have this ...
-3
votes
0answers
21 views

Insert an array of strings into sqlite in android programming [on hold]

Can anyone show me how to store an array of strings in a sqlite db or if it can be done at all?PS: I am doing this as part of an exercise.

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