Welcome To Ask or Share your Answers For Others

Recent questions tagged SQLite

0 votes

796 views

1 answer

sqlite - Can I pickle a python dictionary into a sqlite3 text field?

Any gotchas I should be aware of? Can I store it in a text field, or do I need to use a blob? (I'm ... with some of my high-level design ideas.) See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

sqlite - How to automate a process with the sqlite3.exe command line tool?

I'm trying to bulk load a lot of data ( 5.5 million rows ) into an SQLite database file. Loading via ... db Surely I can do this somehow? See Question&Answers more detail:os...

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

0 votes

843 views

1 answer

sqlite - How do I delete DB (sqlite3) in Django 1.9 to start from scratch?

I made a spelling error in my model and now one of my columns is misspelled. I'd like to drop all tables in ... have a quick way to do this? See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

sqlite - Android threading and database locking

We are using AsyncTasks to access database tables and cursors. Unfortunately we are seeing occasional exceptions regarding ... front or behind. See Question&Answers more detail:os...

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

0 votes

540 views

1 answer

sqlite - SQLite3 FTS4, MATCH and Android

Is SQLite3 FTS4-enabled in the Android build? See Question&Answers more detail:os...

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

0 votes

661 views

1 answer

sqlite - cant use like clause in android app

I am working on a database with sqllite in an android app I want to retrieve sm data using a like clause ... match_str but its not working.Why? See Question&Answers more detail:os...

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

0 votes

806 views

1 answer

sqlite - What is the maximum number of connections for a SQLite3 database?

What is the maximum number of connections for a SQLite3 database? Why can't I use it for very big websites, for example with 3 million users? See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

sqlite - Python Sqlite3 - Data is not saved permanently

I am doing something wrong with SQLite3 and Python 3. Maybe i misunderstood the concept of SQLite Databases, but i ... Where i am doing wrong? See Question&Answers more detail:os...

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

0 votes

574 views

1 answer

sqlite - Merging intervals in one pass in SQL

Let's say I have a table with two columns: start and end, both integers, and the table is ordered by the ... whether it's possible. Can you? See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

sqlite - Android get sum of database column

I need help with summing all the values in one of the columns(amount) in my database. i can a get a particular ... anyone help to me. Thank u See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

sqlite - Rolling rows in SQL table

I'd like to create an SQL table that has no more than n rows of data. When a new row is inserted, I'd ... with some outside (third-party) code? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

sqlite - Using multiple cursors in a nested loop in sqlite3 from python-2.7

I've been having problems using multiple cursors on a single sqlite database within a nested loop. I found ... defect that should be addressed? See Question&Answers more detail:os...

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

0 votes

806 views

1 answer

sqlite - No Such Table error

I had to search for many posts regarding these errors, but still I cannot fix the problem. Here is my code, can ... in opening database "); } } See Question&Answers more detail:os...

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

0 votes

839 views

1 answer

sqlite - How to upgrade sqlite3 in python 2.7.3 inside a virtualenv?

There is a sqlite3 library that comes with python 2.7.3, but it is hardly the latest version. I would like to ... is the correct way to do so? See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

sqlite - Python, Sqlite3 - How to convert a list to a BLOB cell

What is the most elegant method for dumping a list in python into an sqlite3 DB as binary data (i.e., a BLOB ... 0000 0001 # ... # 0000 0101 See Question&Answers more detail:os...

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

0 votes

609 views

1 answer

sqlite - sql query - how to apply limit within group by

I have a table named t1 with following fields: ROWID, CID, PID, Score, SortKey it has the following data: 1, ... I am using SQLite for this. See Question&Answers more detail:os...

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

0 votes

657 views

1 answer

sqlite LIKE problem in android

Hello i've spent almost 2 hours trying to figure out why the LIKE statement doesn't work and i only get this ... a bug? Thanks for your time. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sqlite - DbFunctions.TruncateTime LINQ equivalent in EF CORE

I have the following functioning LINQ in my .net app public ActionResult Index() { Dictionary<DateTime?, List< ... if that makes a difference. See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

sqlite - Updating prepopulated database in Android

I lost last 3 hours trying to do this. Im making an app that will ship with a DB filled with populated tables ... the path to assets from code)? See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

sqlite - Locking a sqlite3 database in Python (re-asking for clarification)

A few weeks ago, I posted this question on SO regarding how to lock a sqlite3 database in python: How to lock a ... a way to make this work? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sqlite - Encrypted file or db in python

I have a sqlite3 db which i insert/select from in python. The app works great but i want to tweak it so no ... i have no idea where to start. See Question&Answers more detail:os...

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

0 votes

681 views

1 answer

sqlite - Android: Sugar ORM No Such Table Exception

I am getting the No Such table exception when i am Using Sugar ORM with GPU image Android Library. ... .query(SQLiteDatabase.java:1238) See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

sqlite - Logging SQL queries in android

I am using the query functions in order to build the SQL queries for my tables. Is there a way to see ... masterQuery, editTable, query); } } See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

sqlite - Phonegap Offline Database

I want to store some large offline data in user phone (more than 100 MB) in an encrypted database. If ... other than writing down my own? See Question&Answers more detail:os...

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

0 votes

539 views

1 answer

sqlite - Best practices for exposing multiple tables using content providers in Android

I'm building an app where I have a table for events and a table for venues. I want to be able to ... so I would appreciate any pointers here. See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

sqlite - Python sqlite3 parameterized drop table

I have a problem with dropping sqlite3 table in python. I am using standard sqlite3 module. self.conn = sqlite3.connect ... """ it works fine. See Question&Answers more detail:os...

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

0 votes

765 views

1 answer

sqlite - Android table creation Failure (near "autoincrement": syntax error)?

public static final String MYDATABASE_NAME = "MY_DATABASE"; public static final String MYDATABASE_TABLE = "MY_TABLE"; ... MY_TABLE (_id)); See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

sqlite - How to generate all dates between two dates

How can I retrieve all dates between '2015-10-02' to '2015-11-02' in SQLite? (String type) Result will be like: ' ... ' 10 '2015-01-03' 0 ... See Question&Answers more detail:os...

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

Page:

« prev
1
2
3
4
5
6
7
8
9
next »

...