Hello,
I have a situation where I need to store the data in local (iphone) and the same data will be in the web server to be accessed by other users (like sending messages) .
For the web server part I am not worrying, I created all the tables and relations.
but I am worrying about Iphone side data storage and sync both sides correctly....
I would like to load/save a dict to/from my sqlite DB, but am having some problems figuring out a simple way to do it. I don't really need to be able to filter, etc., based on the contents so a simple conversion to/from string is fine.
The next-best thing would be foreign keys. Please don't post links to huge examples, my head would exp...
How can I copy records from two Database, "db1.db" and "db2.db" with different column structure?
...
i am very new to Adobe Air and i am having a hard time with it.
i want to be able to create a desktop app for clients that communicates with a databse.
im currently used to writing everything in php, which then communicates with MySQL.
also, i plan on using Flex.
1: does Adobe Air communicate directly with the database? or does it co...
I have to face a new little project. It will have about 7 or 9 tables, the biggest of them will grow by a max rate of 1000 rows a month.
I thought about SQLite as my db... But i will need to protect the db in case anybody wants to change data from the db
My main question is:
Is it possible password protect a sqlite db as you would do ...
I don't like how SQLAlchemy treats datetime values with sqlite databases. It stores the values in plain string format. At the same time sqlite recommends using julianday for storing datetime values.
Is there an easy way to change the SQLAlchemy's behaviour here?
PS. Shall I worry about it? May be noone is dealing with julianday just be...
SQLite docs specifies that the preferred format for storing datetime values in the DB is to use Julian Day (using built-in functions).
However, all frameworks I saw in python (pysqlite, SQLAlchemy) store the datetime.datetime values as ISO formatted strings. Why are they doing so?
I'm usually trying to adapt the frameworks to storing d...
I'm new to working with iphone and SQLite i have my app working fine with SQLite but i would like to know what you all think is the correct / best way of opening an sqlite connection and closing it..
Would you
Initialise a DB connection on app load and close on app close..
Open and close connections when is needed..
Also is it goo...
Hi all!
I have an old project in our company that uses shell scripting a lot. Most popular commands are: grep, sed, sort. And it was OK for now. But one of the thing really bothers me. Sometimes we have an input data from other companies that is in csv-like formats. These input file are connected by several IDs like they are just a dump...
-edit- nevermind, i made a mistake in my select statement. Update was working correctly.
I am not sure why but my sqlite DB isnt updating. I can see that this query returns 1 for a table that is affected but when i close my app or run a certain select statement it is as if this update never happened. 2 notes. 1) My inserts work fine, 2)...
I want to save large amounts of text then display them (first in table view, then in text view), however I am unsure which method to do it in. Should I use SQLite, or one of the archiving methods.
...
i've read the flex language reference:
http://livedocs.adobe.com/flex/3/langref/flash/data/SQLStatement.html#executing
This property is true if execute() has been called and not all of the results have been returned from the database.
however, i'm having trouble understanding what that means exactly. I keep receiving an error:
...
Hi All,
Does anyone know how to create a sectioned Uitableview using sqlite to populate it? I have sqlite database setup, I just cannot figure out how to make sure the correct rows appear in their correct sections. Also, each row/record has multiple fields. For example, lets say it's a list of cars that are sectioned by manufacturer. ...
Hi there,
I'm trying to write two applications (iphone and desktop) to achieve what's been described in the following link:
core-data-is-it-possible-to-build-a-desktop-app-to-create-the-data-model-for-an
Ok. So I've created a very simple desktop app the has a single entity named Client with a string attribute field called name. I've ...
I have an app using SQLite3. It's running pretty well, but I would like suggestions on speeding up SQLite (write) access. Most of the database operations are writing triples (int, int, double) of numbers, about 20-50 triples per second. There is an occasional read, but is about as rare as hen's teeth (mostly occurs on loading only).
Doe...
Hi all,
I am getting an "sqlite3_exce read only data base" error while inserting or updating data into table.
Because initially I have to create number of tables in data base & insert lots of data into it, so I create a one dummy application which create "database.sql" database,create Table & it insert data into the tables.
Now ...
I'm writing desktop app in c# and I need some free reporting system.
Any suggestions?
EDIT:
I'm using SQLite as DB.
...
Right now I'm doing this:
SELECT * FROM messages WHERE location_id = 7 AND date(date) <= date('now', 'localtime') ORDER BY date,revision LIMIT 1
This gives me the most recent message, with the highest revision #.
How can retrieve all of the most recent messages? If I do:
SELECT * FROM messages WHERE date(date) <= date('now', 'local...
I have a simple table, something like: int id, date created_at, date updated_at. I'd like to order the rows so that any rows that have an updated_at will be sorted by that, and any that don't will be sorted by the created_at. The problem is that something like:
SELECT * FROM table ORDER BY updated_at, created_at
doesn't work. I've bee...
I'm using SQLite (3.6.4) from a C++ application (using the standard C api). My question is: once a query has been prepared, using sqlite3_prepare_v2(), and bound with parameters using sqlite3_bind_xyz() - is there any way to get a string containing the original SQL query?
The reason is when something goes wrong, I'd like to print the qu...