Recent questions tagged SQLite

0 votes

848 views

1 answer

sqlite - SQL: Sort by priority, but put 0 last

I have a (int) column called "priority". When I select my items I want the highest priority (lowest number) to ... which I would try to keep. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

631 views

1 answer

sqlite - How to update table schema after an app upgrade on Android?

I have an unfinished application, but I want to address now the future update of it. Suppose my app was upgraded ... use for my above purpose? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

708 views

1 answer

sqlite - Dealing with a large database in Android

I'm currently developing an app that has the potential to create a very large database. I had planned on ... are there any better alternatives? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

907 views

1 answer

sqlite - INSERT OR REPLACE + foreign key ON DELETE CASCADE working too good

I am currently trying to create an sqlite database where I can import a table from another sqlite database (can ... transaction mode / pragma ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.6k views

1 answer

sqlite - Flutter sqflite open existing database

How can open existing db from assets with flutter and sqflite? I read this guide : https://github.com/ ... not found table' error Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

718 views

1 answer

sqlite - Android SQLiteException: Failed to change locale for db to 'en_US'

I recently updated one of my (open-source) Android apps and my users are getting an exception that I can't replicate. ... .java:364) ... 24 more See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

661 views

1 answer

sqlite - Segmentation fault with Rails after upgrading to OS Sierra, possibly related to sqlite3 gem

After upgrading to OSX Sierra I am having an issue with random segmentation faults. It most commonly occurs when ... and then rerun the test. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

656 views

1 answer

sqlite - Opening sqlite3 database from python in read-only mode

While using sqlite3 from C/C++ I learned that it has a open-in-read-only mode option, which is very handy ... a thing in the Python binding? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

623 views

1 answer

sqlite - Android: copy database from asset folder, but only get an empty file

guys, I have the problem when copying database from local assets folder to /data/data/package_name/databases directory ... Thank you very much!! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

887 views

1 answer

sqlite - Opening sqlite3 database from python in read-only mode

While using sqlite3 from C/C++ I learned that it has a open-in-read-only mode option, which is very handy ... a thing in the Python binding? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

777 views

1 answer

sqlite - Android: copy database from asset folder, but only get an empty file

guys, I have the problem when copying database from local assets folder to /data/data/package_name/databases directory ... Thank you very much!! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

784 views

1 answer

sqlite - Android JUnit4 Testing - Where to get Context from?

I have to build an app with sqlite usage. Now I want to write my unit tests. These unit tests should test ... extend without losing Junit4. :) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

694 views

1 answer

sqlite - Simple SQL Lite table/import question

I have a simple SQL question. I want to make a 3 column database and I have the following code: sqlite3 meshdb.db ... KEY to for this to work? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

845 views

1 answer

sqlite - Storing currency values in SQLite3

I'm dealing with lots of different currencies in my application, and I want to know what the "best" ... changes and requires more precision? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

396 views

1 answer

sqlite - Are Aliases to be used outside the Select in which they are declared?

everyone. I have a table with one of the fields (seq) declared as varchar(14), containing a string of numbers (five ... -07' AND '2012-12-24') See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

808 views

1 answer

sqlite - Error using SQL 'With' clause

This is the query that I am using. I am getting an error with this query. 'syntax error near ... , child_customer_type, level FROM under_cust See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

694 views

1 answer

sqlite - Foreign key isn't being enforced

Why is the following foreign key constraint (although executes fine) not enforced by SQLite? How can I go about ... ) REFERENCES User(UserID) ) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

682 views

1 answer

sqlite - Android Room FOREIGN KEY constraint failed

I'm trying to design and implement a folder tree structure in Android SQLite with help of Android Room Persistence ... for my project table? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

577 views

1 answer

sqlite - Share a dict with multiple Python scripts

I'd like a unique dict (key/value) database to be accessible from multiple Python scripts running at the same ... key and value both integers). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

740 views

1 answer

sqlite - Python sqlite3 version

Python 2.6.2 (r262:71605, Apr 14 2009, 22:40:02) [MSC v.1500 32 bit (Intel)] on win32 Type "help", " ... releaselog says 2002 Mar 13 (2.4.1). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

564 views

1 answer

sqlite DB to-do during iphone app update

I have some general questions about iphone app updates that involves sqlite db. With the new update does the ... me guidelines and sample code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

712 views

1 answer

sqlite - Android ContentProvider database query multiple tables

I'm writing an RSS reader for Android. I've faced a certain difficulty which the problem I can't resolve ... the correct way? Thanks, Antek See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

sqlite - SQL -- Remove duplicate pairs

I'm using an SQLite to store a set of undirected edges of a graph using two columns, u and v. For example ... ideas how to achieve this? Thanks! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

905 views

1 answer

sqlite - Update multiple rows with different values in a single SQL query

I have a SQLite database with table myTable and columns id, posX, posY. The number of rows changes constantly (might ... this in AIR by the way. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

968 views

1 answer

sqlite - Valid query to check if row exists in SQLite3

Is this the best(most efficient) way to check if a row exists in a table? SELECT EXISTS(SELECT 1 FROM myTbl WHERE ... bool) or 0(int) or NULL? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

918 views

1 answer

sqlite - Get a list of field values from Python's sqlite3, not tuples representing rows

It's annoying how Python's sqlite3 module always returns a list of tuples! When I am querying a single column, I ... there a way to do this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

807 views

1 answer

sqlite - Android Room Persistence Library: Upsert

Android's Room persistence library graciously includes the @Insert and @Update annotations that work for objects or ... the intended behavior. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

570 views

1 answer

sqlite - How can I display Latin words in Android?

I am a new Android developer. I'm working with a Latin font in my app but I can't get it to work and keep getting ... " + question + "'", null); cur.moveToFirst(); vocabDatabase.c...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags