sqlite3

iphone sqlite3 object allocation memory up but no leaks

Hi All, i've been trying to figure out wh. sqy my object allocation keeps rigth up every time i call this function, Instruments reports no leaks but I get a heck of a lot of object coming from sqlite3_exec --> sqlite3Prepare --> sqlite3Parser --> yy_reduce --> malloc & also a whole bunch from & from sqlite3Step --> sqlite3VdbeExec...

How do I show details view in iPhone App using Sqlite

I am trying out iPhone Apps, coming from C#, I am finding very difficult to grasp the iPhone dev environment. So far, I am able to get my 'Makes' listed in a TableViewController. I now wish to get by 'Models' listed when a Makes is selected. Can someone help me with sample code. Can I use the same TableViewController to show the Models...

SQLite problem selecting two columns as one

Basic table with empname and empdpt. In a Sql Server table, I can do Select empname + ' ' + empdpt as expr1 no problem. Can't do the same using Sqlite!! When I try to combine two columns [with data], I get back a 0. I've tried in sqliteman and sqliteadmin as well as Server Explorer in VS. ...

SQLite parameter substitution and quotes

I have this line that works OK: c.execute('select cleanseq from cleanseqs WHERE newID="%s"'%name) But I want to use SQLite parameter substitution instead instead of string substitution (because I see here that this is safer). This is my (failed) try: t = (name,) c.execute('select cleanseq from cleanseqs WHERE newID="?"',t) But thi...

how can you view or edit a database created in netbeans?

i'm using Netbeans 6.5 for RoR development. I believe my sqlite3 DB is out of synch with rails migrations. how can I view and manipulate the database (through netbeans or command line)? ...

iPhone create SQLite database at runtime?

Most sqlite examples I've found talk about creating a db file from the commandline first and then adding that to your app. For my project, I'd like to be able to create my database within the app when it starts up for the first time and then save it to a db file in the user's sandbox. Is there a way to do that? ...

C# and parameterized SQLite, WITHOUT going through ADO.NET

Is it possible, and if so, how... To do parameterized queries with SQLite WITHOUT having to go through ADO.NET. I've been asked to do some testing with SQLite for a project that needs to have a zero-admin install... ie: no special permissions, things added to windows registry, etc. I would suspect that using an ADO.NET would require s...

install sqlite3 on mac os x?

I am trying update my version of sqlite3 on mac os x 10.5.7 I downloaded the source code that is recommended for unix and unix like programs. I followed the compile and install directions in the readme file and everything seems to work fine. However, when i check the version number of sqlite3 it remains at 3.4.0 (the old version). Wh...

how do i store audio files in sqlite3 database and play them in iphone?

i want to store audio files(any of these formats mp3,wav,and iphone supported) in database and play them in iphone...any idea how to do this? ...

PHP with sqlite3 support

How do I know if PHP is compiled with SQLite support? If it's not, and I don't have the privileges to change it, what alternatives do I have to read an SQLite database besides access to php-sqlite3 functions? ...

How do I install/use the phpize command?

I am intending to use SQLite 3 with PHP 5. I found this: http://packages.debian.org/etch/web/php5-sqlite3 but I am having problems with installation: unzip & untar the package run "phpize" run "./configure --with-sqlite3=/path/to/your/sqlite3/install make && make install (optionally) copy DB/sqlite3.php to /path/to/php/lib/php/DB/sqlit...

How to break subquery into 2 simple query

Hi , I am trying some way to optimize following sql statement: exe_sql "DELETE FROM tblEvent_type WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; exe_sql "DELETE FROM tblEvent_group WHERE eguid in (SELECT rowid FROM tblEvent_basic WHERE sguid=11);"; It is said that sqlite3 did not perform well in subquery and not...

Sqlite binding within string literal

Using sqlite3, if my query is SELECT * FROM table WHERE title LIKE '%x%' It will match strings that contain x. I want to make x a bindable parameter, like: SELECT * FROM table WHERE title LIKE '%x?%' However, this does not work since the '' form a string literal. Is there some way of escaping the ? within the literal? I understand th...

how to insert contents of a file into a blob column in a table using sqlite3

Hi everyone i need to insert the contents of a file into a blob column in sqlite3 but the thing is that i just wanna know whether it is possible by command line statement regards shroff ...

what is the performance difference of sqlite3_exec() and sqlite3_get_table()

Hi , I want to know what is the performance difference between sqlite3_exec() and sqlite3_get_table(). is there a performance difference...? ...

Why can't IPython return records with multiple fields when submitting a query to sqlite?

I am trying to write a simple query to an sqlite database in a python script. To test if my parameters were correct, I tried running the query from the ipython command line. It looked something like this: import sqlite3 db = 'G:\path\to\db\file.sqlite' conn = sqlite3.connect(db) results = conn.execute('SELECT * FROM studies').fetchall()...

Any good tools to migrate from MySQL to SQLite3?

I'm struggling to find a good tool to help me migrate a MySQL database to SQLite. I've seen a couple of different Perl scripts (including one discovered here), but they do not appear to work correctly for me. ...

sqlite3 error "not an error" on iPhone SDK

Im getting an error "not an error" on iPhone SDK, I spent a whole day trying to resolve it. SQLite version 3.4.0 sqlite3_step(compiledStatement) The table I'm using in the query has only one row. It returns 100..? sqlite3_errmsg( database ) This line gives me the above error. I've created a database and tables in it with terminal ...

iphone warning libsqlite3.dylib is not of required architecture?

I'm writing an iPhone app which seems to run fine on the simulator, however when I try and run it on the device I get a libsqlite3.dylib, file is not of the required architecture error. I'm using os 3.0 on a 3GS. Any ideas on what could be causing this? Thanks! ...

Install sqlite3 on mac osx?

I just bought a new MBP I've read online Sqlite3 already exists on OSX. I've downloaded mac ports (and installed it) as well as the bin file for sqlite3 from the official web site. In a guide I'm reading about rails, which tells me to update sqlite3, I run the following in terminal: sudo port upgrade sqlite3 I receive the following ...