Questions tagged [SQLite] (497)

2
answers

How to make Cogear to use a Sqlite database?

Appeared need to use Cogear with Sqlite database. Since it is based on Codeigniter which supports these database problems, I think, should not be. Where to dig?
harvey asked October 14th 19 at 12:14
1
answer

Application for work with databases on Windows Mobile

if there are any applications to work for example with SQLite on Windows Mobile? Only interested in finding records on the selected database and displays them. Or any more or less open counterparts database. Search on Google gave nothing.
kallie asked October 14th 19 at 10:17
1
answer

The DataGridView doesn't want to display null?

VS 2010, a small project in WinForms. As a database using sqlite3. A regular table to a dataGridView on the form is populated with data from database through DataSource. If the database has no null entries, everything works fine. If suddenly there was such, it gives an error ConstraintException and marks the field with an e...
flavie15 asked October 10th 19 at 14:07
3
answers

Optimization in SQLite

There is a need to accelerate the search in SQLite DB in one iPhone project. The base is large, over a million records. There are several text fields, varchar for which the search is conducted. Information in Russian UTF8. Currently used LIKE + custom translation function to lowercase. The problem is that in this case yo...
Velda66 asked October 10th 19 at 06:52
1
answer

Android SQLite — need help with blobs?

Trying Android store pictures in blobs (using byte[]). Saved, like, good. Viewing SQLite database Manager-om in Mozilla shows that the data is. Then get those blobs from the database using cursor.getBlob(columnIndex) — get is always null. culumnIndex like, right. The other fields in the same query is no problem, but they ar...
Aric asked October 10th 19 at 03:41
1
answer

C# + sqlite, a few questions

In my previous question I asked about the language, and so decided to start writing a program in C# But since the language is new to me immediately raised some questions. Some have decided with the help of Google, but the database has the problem. Connect to sqlite using ADO.NET (http://sqlite.phxsoftware.com/) Using VS t...
flavie15 asked October 10th 19 at 03:07
2
answers

Cyrillic in SQLite, Android?

No matter how much I searched, in Android you cannot set a custom function for SQLite. However, my task is the search for our database. The problem is that the comparison is LIKE not understand upper and lower case Cyrillic, UPPER and LOWER do not work for Cyrillic. In iOs I decided its functions, and here I can not. How to...
deion_Schup asked October 9th 19 at 22:20
4
answers

Tools for working with remote SQLite FTP

Good afternoon. Transferring part of the non-critical things with storing serialized data in sqlite. Are there any tools(free) which allow you to work with a remote sqlite eg. FTP? Need the basic features for creating tables, modifying structure, content management... Thanks in advance!
horacio.Daugherty asked October 9th 19 at 21:43
5
answers

Podskajite how to create sqlite tables from mysql

Working on a small guide for Android. Web version of the directory works with multiple tables mysql. Tell me how a way to get this mysql table in Android sqlite? And how in the future update of the app?
velva_Fah asked October 8th 19 at 07:39
1
answer

Ios/android library for creating a data model to be able to boot from the network and the local cache?

Good afternoon. The challenge is to make apps for ios and android, whose main task is to download data from the server, cache them locally, display, and update. UI is going to do for each platofrm — your. Data is a list with text, html, pictures. The task is very popular, so I'm sure it's been done many times before. Maybe ...
Ahmad.Muller39 asked October 8th 19 at 05:52