Tagged Questions
2
votes
0answers
156 views
How to integrate sqlite extensions in XAMPP?
There's an extension on the http://www.sqlite.org/contrib?orderby=date, extension-functions.c, which integrates the SQRT command in sqlite.
How can I integrate this and use it in my Windows-XAMPP ...
2
votes
0answers
131 views
Search SQLite database in android with regional chars (pt_PT) and case insensitive
How to search a table (tbl) with this records:
_id name
----- ----------
1 antónio
2 antonio
3 antõnio
4 ANTONIO
5 ANTÓNIO
select * from tbl where name like "%to%" COLLATE ...
2
votes
0answers
1k views
Android MediaStore get distinct folders of music files
Looking for the way to get only folder paths of music files from Android MediaStore for inputted directory path. So actually question is about how to make proper query to the MediaStore.
Here is an ...
2
votes
0answers
303 views
iOS sqlite data from SQL server
I need to get large data (~100MB) from sql server into app's sqlite once a day wirelessly.
App has json/restful webservice for other things, but figured this isn't possible as 100MB loaded into ...
2
votes
0answers
108 views
sqlite insert new value into view
I would like to make sure I did everything in a right way.
There is a 3Gb log file which I want to analysis.
In order to execute all queries in ":memory:" to boost the performance,
I replace the 10 ...
2
votes
0answers
199 views
32bit Python not working with sqlite3
I have a very weird problem, my 64 bit python works fine with sqlite3, there are no errors when I import sqlite3. However, my 32 bit python won't work, here's the error message. I installed python ...
2
votes
0answers
338 views
How to check if BLOB is null
How do you check whether the value of a column in a SQLite database is null, if it is of type Blob?
I am fetching a Cursor like so:
public Cursor fetchArticle(int i) throws SQLException {
...
1
vote
0answers
46 views
What type of SQL does Red Query Builder generate?
I have been trying to use Red Query Builder visual query builder on a project, but we are finding that the SQL output is not consistent with the SQL our database (SQLite) expects. That makes me wonder ...
1
vote
0answers
106 views
SQL Server and SQLite replication of data via USB (Android)
I have a project which I am trying to sync SQL server database and SQLite database via usb. I can currently connection directly to the SQL Server database via WiFi and use this data real time or I can ...
1
vote
0answers
41 views
How to compare arbitrary tables for differences in sqlite
I'm trying to compare data from two tables with identical columns, looking for differences. One table represents the 'live' data, and the other is effectively an archive:
Tables: Live, Archive
...
1
vote
0answers
105 views
Combined trigger in SQL
I have these tables:
Movie ( mID, title, year, director )
Reviewer ( rID, name )
Rating ( rID, mID, stars, ratingDate )
and some views:
View LateRating contains movie ratings after January ...
1
vote
0answers
77 views
why do you have to execute sqllite statements asynchronously on iOS to get results?
I'm using the remail project code, and I was trying to search the sqllite database to match subjects with the sender and receiver fields in order to establish email threading (I know.. jwz advised ...
1
vote
0answers
86 views
SQL parameterised Insertion Union Query
I have been successful with multiple insertion with around 200 records but my problem is order in which the data is being inserted.The records are inserted in SD_0, SD_1, SD_10, SD_100, ..so on.
My ...
1
vote
0answers
62 views
How to ignore corrupted rows when importing the file to SQLite?
Is there any way to ignore the corrupted lines in a file when importing them to a table using SQLite 3 on Linux? The file size is 13GB and there are around 50 corrupted lines in the file, so manually ...
1
vote
0answers
156 views
SQLite slows down machine on bulk insert
I am using the system.data.sqlite wrapper for an application that caches a large amount of data. Almost all of this data goes into 1 table with 3 columns. The data from the cache is pulled down from ...