Tag: sqlite

2657 Improve INSERT-per-second performance of SQLite? 2009-11-10T22:16:43.493

1065 How to list the tables in a SQLite database file that was opened with ATTACH? 2008-09-17T12:59:53.633

972 Select first row in each GROUP BY group? 2010-09-27T01:23:22.873

788 How do I check in SQLite whether a table exists? 2009-10-21T14:22:10.480

645 What are the best practices for SQLite on Android? 2010-03-22T15:13:32.573

547 Sqlite primary key on multiple columns 2009-04-09T15:17:31.807

506 What 'additional configuration' is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project? 2010-03-16T15:26:55.223

501 Is it possible to insert multiple rows at a time in an SQLite database? 2009-10-22T20:04:42.983

468 SQLite - UPSERT *not* INSERT or REPLACE 2009-01-07T01:47:23.903

387 Is there an SQLite equivalent to MySQL's DESCRIBE [table]? 2010-07-25T18:23:02.510

314 Java and SQLite 2008-09-03T06:10:15.297

308 Core Data vs SQLite 3 2009-02-07T09:05:09.117

298 What are the performance characteristics of sqlite with very large database files? 2009-04-24T01:09:33.047

298 Insert new column into table in sqlite? 2010-11-23T07:45:36.670

298 How to use an existing database with an Android application 2012-02-02T08:54:28.130

285 How to get a list of column names on sqlite3 / iPhone? 2009-06-03T20:59:14.110

276 Any good ORM tools for Android development? 2008-12-16T14:47:26.417

263 Is there a .NET/C# wrapper for SQLite? 2008-09-18T15:36:48.053

259 How to get Top 5 records in SqLite? 2010-04-28T11:33:01.390

258 When is SQLiteOpenHelper onCreate() / onUpgrade() run? 2014-02-19T13:31:07.150

255 How do I rename a column in a SQLite database table? 2009-04-30T04:43:45.010

246 Version of SQLite used in Android? 2010-03-10T22:37:23.363

230 INSERT IF NOT EXISTS ELSE UPDATE? 2010-09-03T10:47:14.647

224 Store boolean value in SQLite 2009-05-09T18:13:12.230

221 How do I unlock a SQLite database? 2008-09-29T22:35:49.277

216 Best way to work with dates in Android SQLite 2011-09-09T14:22:23.900

209 Mac SQLite editor 2008-09-19T10:24:18.450

208 Create table in SQLite only if it doesn't exist already 2010-11-04T15:04:15.630

202 Quick easy way to migrate SQLite3 to MySQL? 2008-08-20T19:49:13.337

197 How to delete or add column in SQLITE? 2011-12-09T07:03:55.607

178 How to concatenate strings with padding in sqlite 2011-05-26T06:11:51.527

177 What is the best extension name SQlite database files? 2009-04-30T18:54:15.993

173 What is a good choice of database for a small .NET application? 2011-07-19T15:16:33.210

167 How Scalable is SQLite? 2008-09-10T18:47:58.067

164 How do I dump the data of some SQLite3 tables? 2008-09-16T18:52:49.690

164 SQLite table constraint - unique on multiple columns 2010-04-23T20:45:37.420

163 Get boolean from database using Android and SQLite 2010-11-03T14:29:52.327

158 sqlite database default time value 'now' 2008-10-14T07:56:27.897

153 Android search with Fragments 2011-08-29T13:37:06.917

148 Creating stored procedure and SQLite? 2010-07-26T13:23:53.893

146 Unable to load DLL 'SQLite.Interop.dll' 2012-10-23T10:06:45.540

140 Escape single quote character for use in an SQLite query 2009-03-02T19:12:36.583

140 How to delete SQLite database from Android programmatically 2010-12-10T05:47:12.987

138 How to delete all record from table in sqlite with Android? 2012-03-07T10:30:20.317

134 sqlite alter table add MULTIPLE columns in a single statement 2011-05-30T06:08:26.720

132 Sqlite LIMIT / OFFSET query 2010-07-24T14:45:47.250

132 SQLite: How do I save the result of a query as a CSV file? 2011-05-20T19:57:13.623

130 How to retrieve inserted id after inserting row in SQLite using Python? 2011-06-05T11:59:13.783

128 Pros and Cons of SQLite and Shared Preferences 2011-06-08T08:54:11.083

127 Get generated id after insert 2011-03-23T18:16:01.023

125 How to use SQL Order By statement to sort results case insensitive? 2010-03-09T23:30:55.843

122 String concatenation does not work in SQLite 2010-08-25T17:49:30.150

118 Could not load file or assembly 'System.Data.SQLite' 2009-08-14T16:45:50.340

118 Change from SQLite to PostgreSQL in a fresh Rails project 2011-07-15T17:05:21.307

117 SQLite in Android How to update a specific row 2012-03-21T04:07:06.250

116 How do I view the SQLite database on an Android device? 2013-10-05T06:03:09.867

115 SQLiteDatabase.query method 2012-05-15T12:29:23.710

113 Copying data from one SQLite database to another 2010-03-01T21:30:34.060

112 How do you rename a table in SQLite 3.0? 2009-01-08T23:36:39.627

112 How to import load a .sql or .csv file into SQLite? 2009-06-25T19:57:44.663

111 How do I add a foreign key to an existing SQLite table? 2009-12-10T23:22:50.993

111 Is an index needed for a primary key in SQLite? 2010-07-31T18:18:01.083

111 Convert NSData to String? 2011-06-21T16:05:07.880

109 List of tables, db schema, dump etc using the Python sqlite3 API 2008-11-20T14:00:23.947

109 SQLite select where empty? 2010-09-01T18:00:15.327

109 sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied 2013-05-31T11:51:17.800

106 Android: upgrading DB version and adding new table 2011-11-15T08:45:56.213

106 Create SQLite Database and table 2013-03-08T11:24:59.043

105 Light weight alternative to Hibernate? 2008-11-17T19:25:24.993

105 Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine 2008-12-19T15:53:32.940

105 How to have an automatic timestamp in SQLite? 2013-01-22T15:17:51.017

102 How to insert a SQLite record with a datetime set to 'now' in Android application? 2009-04-16T03:43:48.950

102 Where does Android emulator store SQLite database? 2009-10-02T17:20:32.160

102 Convert MySQL to SQlite 2010-10-08T12:38:12.340

101 SQLite DateTime comparison 2009-12-29T17:12:56.963

101 What is the syntax for "not equal" in SQLite? 2012-02-21T22:28:03.130

101 FMDBBlockSQLiteCallBackFunction Crash in app that's not using makeFunctionNamed 2015-06-08T16:17:55.957

100 SQLite: read-only database 2010-07-23T14:31:03.430

100 Is there type Long in SQLite? 2011-12-29T19:29:05.473

100 Set default value of an integer column SQLite 2013-07-12T14:43:29.413

98 How do I insert datetime value into a SQLite database? 2009-12-19T18:19:44.570

98 What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT? 2010-05-03T22:11:40.457

97 How to convert byte array to Bitmap 2011-10-01T13:08:04.933

96 SQLite Reset Primary Key Field 2009-10-21T15:38:48.843

94 Android SQLite: nullColumnHack parameter in insert/replace methods 2010-04-18T16:17:27.473

94 IN clause and placeholders 2011-09-14T15:21:46.367

93 Select random row from a sqlite table 2010-02-17T10:04:53.267

91 Why do you need to create a cursor when querying a sqlite database? 2011-06-11T19:41:17.850

90 SQLite add Primary Key 2009-06-03T17:25:38.387

90 Best practices for exposing multiple tables using content providers in Android 2010-09-28T14:49:35.853

90 How do DATETIME values work in SQLite? 2013-06-21T03:11:10.400

89 How do I make an UPDATE while joining tables on SQLite? 2009-04-21T16:19:46.173

89 Android SQLite DB When to Close 2010-12-29T19:25:47.567

89 How do I join two SQLite tables in my Android application? 2011-02-10T12:22:36.730

89 Android - Pulling SQlite database android device 2012-04-03T17:02:49.533

89 Accessing an SQLite Database in Swift 2014-06-08T03:39:44.847

88 Location of sqlite database on the device 2010-12-15T16:47:22.163

88 SQLite Query in Android to count rows 2011-03-05T06:58:47.970

88 Delete column from SQLite table 2011-05-09T14:09:14.903