What should i know about switching from sqlite to SQL Server
Currently i have no way to test my code with SQL Server. I know nothing about it and have been using SQLite. What should i know while switching? My app is programmed in C# .NET ...
sqlite
Sqlite group_concat select with "special needs"
I know how to use group_concat with Sqlite, to do the following: id - f1 - f2 - f3 1 - 1 - a - NULL 2 - 1 - b - NULL 3 - 2 - c - NULL 4 - 2 - d - NULL select id, f1, group_concat(f2), f3 from table group by f1 result: 2 - 1 - a,b - NULL 4 - 2 - c,d - NULL as you can see, the ID's 1 and 3 are dropped, which is the ...
Android: Accessing single database from multiple activities in application?
I have a todo list type application that stores all of the note data in a sqlite3 database. Each activity in the application needs access to the database to edit different parts of the data in real time. Currently, I have each activity open its own DBManager object (the helper class I created to manage the database). This is causing p...
How can I overwrite the contents of an SQLite file
I've just started using SQLite and I want to write all my application data to a file, not knowing if the file exists already; with 'normal' files, this is straightforward, but with SQLite I can't create a table if it already exists, and I can't insert a row if the primary key already exists. I basically want to do something like "CREATE...
SQLite load db dump from code
I have database dump and I want load it to sqlite database on iphone at runtime. How i can do it from code? ...
SqlMetal fails to create DBML from Sqlite Database
I'm trying to use the new Mono 2.6 SqlMetal tool to create the DBML file for a simple Sqlite Database. The schema is really simple as follows: CREATE TABLE Tags ( Id INTEGER PRIMARY KEY, TagName TEXT, Description TEXT); CREATE TABLE Trends ( TagId INTEGER NOT NULL, Timestamp ...
Using Flex to keep local SQLite database in sync with live server database
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website. Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this? Edit: The synchronisation can be d...
Using Database storage for uses other than offline apps
I've been looking into offline database storage with HTML5 and the built in Sqlite Db. I think it has a potential for things other than just storing data for offline apps. What I'm interested in, is hearing about potential uses of the database for storing things other than offline web page content. What has anyone in the commnity been u...
How to update and select a row within one query in SqLite?
I want to update and select one row within one query in SqLite. In MySql my wanted query would look like this: SET @update_id := -1; UPDATE data SET `Status` = 'running', Id = (SELECT @update_id := Id) WHERE `Status` = 'scheduled' LIMIT 1; SELECT * FROM data WHERE id=@update_id;" The above query will set the Status to 'running' and...
FULL OUTER JOIN with sqlite
sqlite only have INNER and LEFT JOIN. Is there a way to do a FULL OUTER JOIN with sqlite? ...
SQLite Query using nested SELECT
I'm trying to select cpu_time from the db, but the time must correspond with a few other criteria - i.e. build_version, test_letter, design_index, multi_thread, and test_index What I thought would work was (the inner SELECT DISTINCT statement works on its own): set query [db eval \ {SELECT DISTINCT cpu_time WHERE cpu_time IN ...
List enumeration in SQL?
Say, there are 2 tables: Person | id | name | LanguagesSpoken | person_id | language_name | Is there a way to create a view that would contain 2 columns: person_name and languages_spoken as a comma-separated list? I'm developing against SQLite. ...
Unit testing Android apps and specifically related to db's
What is the easiest way to create some kind of test harness for Android apps and to be able to visualize (even on the emulator) what is going into the db? I want to test things like constraints, look at the data, unit test methods, etc. Is there any kind of GUI tool that I can hook up to the emulator to be able to look at the db of a p...
Fluent NHibernate - need multi-program access to a single, lazy loaded SQLite database
I'm developing a project that has multiple programs that share a single, lazy loaded SQLite database file, using Fluent Nhibernate (Auto Mapping) as the data access layer. The first program I developed (let's call it Program 1) kept the Session open all the time, and lazy loading worked fine. This approach failed when I got Program 2...
C# and sqlite basics
How to connect, create DB, use it in VS08 (05 or 10 will be ok)? (Vsualy better not writting lots of code=)) need for tutorials libs blogArticles ...
How to work with SQLite in WPF
I havve WPF APP I want to use SQLite How to do such thing? (BTW I understend how to do such thing in adobe Air but in WPF it's a beeg Question for me so some explanation made on\with comparing how to's is Big +...) ...
How do I insert datetime value into a SQLite database?
I am trying to insert a datetime value into a SQLite database. It seems to be sucsessful but when I try to retrieve the value there is an error: <Unable to read data> The SQL statements are: create table myTable (name varchar(25), myDate DATETIME) insert into myTable (name,mydate) Values ('fred','jan 1 2009 13:22:15') ...
Any recommendations for Sqlite C# ORM code generation
Hi, Can anyone recommend an Sqlite C# ORM code generation tool. I have found the Habanero framework, any comments on that? Thanks UPDATE I have gone with Subsonic in this instance. To help anyone else out, here is a 'basic' example of creating a class and using Subsonic and Sqlite together. using System; using System.Collections.Ge...
How remove the warning "large integer implicitly truncated" for sqlite/unicode support?
I use the solution of http://ioannis.mpsounds.net/2007/12/19/sqlite-native-unicode-like-support/ for my POS App for the iPhone, and work great. However, as say in the comments: For instance, sqlite_unicode.c line 1861 contains integral constants greater than 0xffff but are declared as unsigned short. I wonder how I should cope with ...
How to populate a label field from a selected row in a uitableview
I have a uitableview that is populated from a sqlite query. I want to select or click on a row and then display that row's value in a uilabel field. To show the user that the row was selected. I also want to pass that value on to different controllers that will be called later. Here is a copy of my cellForRowAtIndexPath: - (UITableVi...