Questions tagged [sqlite]

13

votes

6

answers

How to insert random data into a SQLite table using only queries?

sqlite

asked 2013-07-29T18:18:17.713

29

votes

3

answers

Database structure for "customer" table having many orders per customer and many items per order

sql database sqlite

asked 2013-07-17T22:24:03.510

9

votes

1

answers

Active Record set_table_name error for .sqlite file

ruby sqlite activerecord ruby-on-rails-4

asked 2013-07-05T23:38:12.403

19

votes

3

answers

Could not allocate CursorWindow

android sql database sqlite android-cursor

asked 2013-07-05T19:30:03.707

19

votes

2

answers

iOS CoreData - are there any disadvantages to enabling sqlite WAL / Write-Ahead Logging

ios sqlite core-data

asked 2013-07-05T10:59:12.757

48

votes

17

answers

Table accounts has no column named otherNotes

android sqlite android-sqlite

asked 2013-07-03T07:18:17.690

23

votes

2

answers

SQLiteQueryBuilder.query() vs SQLiteDatabase.query()

android sqlite

asked 2013-06-21T07:39:41.480

10

votes

1

answers

Does SQLite support referential integrity?

django django-models sqlite referential-integrity

asked 2013-06-20T12:17:16.767

8

votes

4

answers

"sqlite3.OperationalError: database or disk is full" on Lustre

sqlite

asked 2013-05-22T06:37:19.417

68

votes

8

answers

Create a foreign key in SQLite database browser

sqlite

asked 2013-05-14T07:13:05.483

104

votes

5

answers

python 3.2 UnicodeEncodeError: 'charmap' codec can't encode character '\u2013' in position 9629: character maps to <undefined>

python python-3.x sqlite

asked 2013-05-02T20:13:49.157

13

votes

1

answers

What is the correct way to setup database with DataMapper and Sinatra on production server?

ruby sqlite sinatra datamapper

asked 2013-05-02T08:19:37.723

64

votes

5

answers

Connect to a Database in Flask, Which Approach is better?

python sqlite flask

asked 2013-05-01T02:36:42.490

15

votes

5

answers

How to browse Core Data in my app running on my iPhone?

iphone ios xcode sqlite core-data

asked 2013-04-14T23:28:09.097

25

votes

2

answers

Import csv into sqlite with autoincrementing primary key

database csv sqlite

asked 2013-04-13T23:58:18.163

9

votes

3

answers

Insert values into SQLite database manually

android sqlite

asked 2013-04-10T15:40:16.897

8

votes

1

answers

What is the time complexity of INSERT, UPDATE and SELECT in SQLite?

sqlite time insert sql-update complexity-theory

asked 2013-04-09T08:01:29.523

11

votes

5

answers

Entity Framework MigrationSqlGenerator for SQLite

c# .net entity-framework sqlite migration

asked 2013-04-08T19:19:25.143

55

votes

7

answers

Transactions with Python sqlite3

python-2.7 sqlite python-db-api

asked 2013-04-06T22:58:01.230

16

votes

1

answers

Sqlite create unique pair of columns

sqlite unique

asked 2013-04-04T18:42:58.107

37

votes

6

answers

How can I calculate the median of values in SQLite?

sqlite median

asked 2013-04-02T12:19:36.497

13

votes

4

answers

checking if record exists in Sqlite + C#

c# sqlite c#-4.0

asked 2013-03-28T14:09:58.360

11

votes

2

answers

SQLiteException: near "" :syntax error (code 1) while compiling

android sqlite exception

asked 2013-03-23T18:22:35.437

8

votes

4

answers

Store NaN values in SQLite database

sqlite system.data.sqlite

asked 2013-03-22T11:57:53.123

29

votes

5

answers

sqlite3.Warning: You can only execute one statement at a time

python sqlite

asked 2013-03-20T01:46:21.260

8

votes

1

answers

Android SQLite - New table VS. new DB

java android sql database sqlite

asked 2013-03-19T12:11:17.240

52

votes

6

answers

Inserting current date and time in SQLite database

sqlite android-sqlite

asked 2013-03-18T09:25:05.223

8

votes

2

answers

(iOS) Offline Sync DB - Server

ios objective-c sqlite synchronization

asked 2013-03-12T13:11:23.300

23

votes

5

answers

java.lang.IllegalStateException: attempt to re-open an already-closed object(Tried closing )

android sqlite android-sqlite

asked 2013-03-11T12:16:47.957

9

votes

4

answers

sqlite3 import with quotes

sqlite csv

asked 2013-03-04T22:36:11.077

10

votes

2

answers

FMDB ios no such table

ios sqlite fmdb

asked 2013-03-02T17:12:46.657

11

votes

3

answers

SQLite return wrong week number for 2013?

sqlite strftime week-number

asked 2013-02-26T06:14:55.403

14

votes

2

answers

"SELECT ... WHERE ... IN" with unknown number of parameters

python sqlite

asked 2013-02-23T14:23:36.727

13

votes

6

answers

Error Cannot perform this operation because the connection pool has been closed

android sqlite

asked 2013-02-20T09:47:09.160

186

votes

11

answers

Import CSV to SQLite

sqlite

asked 2013-02-19T00:41:57.253

20

votes

4

answers

"Best" Input File Formats for C++?

c++ json sqlite xml-parsing file-format

asked 2013-02-05T03:43:23.820

9

votes

3

answers

How to replace existing sqlite database file with new database file in android

android sqlite android-sqlite

asked 2013-02-04T11:19:52.663

67

votes

3

answers

How to convert Unix epoch time in SQLite

sql sqlite unix epoch

asked 2013-01-31T15:33:04.033

60

votes

4

answers

SQLite syntax for If Else condition

sql sqlite

asked 2013-01-29T10:06:25.213

9

votes

1

answers

Getting SQLite database by adb shell in cmd

android sqlite

asked 2013-01-24T11:03:55.347

8

votes

3

answers

Insert JSON data into the SQLite database in android

android json sqlite android-sqlite sqliteopenhelper

asked 2013-01-21T15:02:32.107

25

votes

2

answers

Sqlite: How to cast(data as TEXT) for BLOB

sqlite casting

asked 2013-01-21T08:45:33.763

75

votes

1

answers

Convert Text to Numbers in SQLite

sqlite

asked 2013-01-13T21:38:31.367

37

votes

7

answers

How can I select rows by range?

sql sqlite

asked 2012-12-28T11:27:52.807

16

votes

5

answers

Is there a Javascript library for localStorage to emulate SQLite

javascript sql sqlite local-storage

asked 2012-12-25T21:16:49.193

22

votes

3

answers

SQLite foreign key examples

python sql sqlite insert foreign-keys

asked 2012-12-18T14:23:16.703

10

votes

1

answers

How do I use a Levenshtein distance function in a sqlite where clause?

ruby-on-rails sqlite levenshtein-distance

asked 2012-12-18T07:32:40.233

46

votes

14

answers

Getting [SQLITE_BUSY] database file is locked with select statements

java hibernate jpa sqlite

asked 2012-12-15T09:24:06.500

25

votes

5

answers

Python sqlite3 string variable in execute

python sqlite

asked 2012-12-14T14:39:49.710

8

votes

1

answers

SQLite delete from only if the table exists

sql database sqlite

asked 2012-12-05T17:23:38.933

Questions tagged sqlite