How to update first n records in SQLite
Hi, Is there any querry available to update only first n records of SQLite DB ..? ...
sqlite
How to write Data Base application in iPhone
Hi I am create an iPhone app, which will use SQLite as database. This database is synchronized by websever by XML HTTP request. The problem is, I don't have pre-build architecture for creating database app. Is there any tutorial which will guild me how to write Data Access Layer(DAL) or how to import SQLite file with iPhone in secured ...
Installing SQLite3 on Windows - what's the current easiest route?
Am brand new to Ruby looking to get Redmine to run on WinServer08 sp1 I've read a few threads here detailing the steps and workarounds required to get Ruby and SQLite to play nice with each other. Ruby will run...sqlite3's .dll and api are in the specified directories...i've rebooted but rake -test fails. I'd like to find out if ther...
SQLite and Flex
I am developing a GPS calculator that uses a lot of data to calculate different values, such as RMSE (root mean square error) and NSSDA (national standard for spatial data). The data is from a variety of different models of GPS units with a great degree in variation, i.e. internal/external antennae; auto, WAAS, DGPS, PPS signal; open, l...
Fast, searchable dict storage for Python
Current I use SQLite (w/ SQLAlchemy) to store about 5000 dict objects. Each dict object corresponds to an entry in PyPI with keys - (name, version, summary .. sometimes 'description' can be as big as the project documentation). Writing these entries (from JSON) back to the disk (SQLite format) takes several seconds, and it feels slow. ...
Interacting with external SQLite databases from Android.
I'm trying to work with a web service (that I have no control over) that returns a SQLite database when you query it. Is there any way to do this? ...
PHP / SQLite - Copying a table from disk to memory
I have a sqlite3 database on my harddrive (file.db) with 5 tables. I'd like to copy 3 of these tables to an in-memory database (:memory:). Is there a simple way to do so using PHP5's PDO format? ...
SQLite + Core Data Vs. File system on Iphone App that shows photos. What's more performant?
Hello, I have an application where the user will navigate around a set of photographs. What's best in terms of performance for this scenario, SQLite + Core DATA for persisting the photos as NSData objects or having the photos as png files directly on the file system? thanks. ...
SQLite - Limitation? Bug? Prepared Statements with HAVING clause
I have a query that is run 1000s of times which I'm trying to optimize using prepared statements: $query = "SELECT day, ticker, SUM(score*mod) as shares FROM indicators, modifiers WHERE indicators.dex=modifiers.dex AND ticker='$t' GROUP BY day, ticker HAVING shares>=$s"; When I run the query normally: $transactions = $dbm->query($que...
Trying to speed up a SQLITE UNION QUERY
I have the below SQLITE code SELECT x.t, CASE WHEN S.Status='A' AND M.Nomorebets=0 THEN S.PriceText ELSE '-' END AS Show_Price FROM sb_Market M LEFT OUTER JOIN (select 2010 t union select 2020 t union select 2030 t union select 2040 t union select 2050 t union select 2060 t union select 2070 t ) as x LEFT OUTER JOIN sb_Selection S ON S....
Is mysql_num_rows efficient and/or standard practice?
A while ago I was poking around with SQLite, trying to port some of my sites to use it instead of MySQL. I got hung up on the lack of a function to count results, like PHP's mysql_num_rows(). After searching a little I discovered this mail list, which says (as I understand it) that SQLite doesn't have that functionality because it's inef...
Sqlite database locked
I'm using asp.net c# and upload a SqLite database to a server and then I do some inserting and updating. The problem is that sometimes (I think it's when somethings go wrong with the updating or so) the database gets locked. So the next time I try to upload a file again it's locked and I get an error saying "The process cannot access the...
free sqlite tools
looking for a free sqlite tool, any suggestions? I need a export, import functionality. Thanks for the recommendation. ...
SQL - Query Help: Finding a Local Maximum
I have a table which has data from a graph. for example index value 0 3 1 5 2 7 3 6 4 8 5 9 6 12 7 11 8 10 9 14 10 13 I need to a query that returns the results where the value is at a local maximum, i.e. the value at a particular index is greater than the value at index+1 and in...
Add images via Push Notification Service?
I have a content app and would like to notify users of new content using Apple Push Notification Service, bypassing the now very long App Store submissions. Once the user receives the notification, a download update button will become enabled. The user will download an sql file plus images from my website. The sql file will execute in...
Inserting date in sqlite db using adobe air and javascript
I am trying to insert a date value in sqlite db using air and javascript. The value gets inserted but when I try and view it, it says null. Later I found that SQLite stores date using julian format. How to convert a javascript date object to julian format? ...
Mapping obj-c object to sqlite database
Hello Im looking for a simple (if I can call it that) mapping tool for obj-c, that maps objects and their relationships to a sqlite database. Is there any out there that acts like db4o for java? I havent found anything on google, and I think its because Im not completly sure of where to look and what to look for. Hope someone can help, ...
Adapter not loading anything with SQLite C#
Hello , I use this code and SQLite says "Data Source cannot be empty. Use :memory: to open an in-memory database" here is my code string dbfile = new System.IO.FileInfo(System.Reflection.Assembly.GetExecutingAssembly().Location).DirectoryName + "\\m23.db"; string sql; DateTime dt = DateTime.Now; SQLiteCon...
How to get Firefox bookmarks from a Delphi application?
I know how to get the favourites from IE, but how can I access Firefox's bookmarks? Here's the code I have for retrieving the IE favourites: uses ShlObj, ActiveX; function GetIEFavourites(const favpath: string): TStrings; var searchrec: TSearchRec; str: TStrings; path, dir, FileName: string; Buffer: array[0..2047] of Char; ...
Set ConnectionTimeout in System.Data.SQLite
I think that I'm experiencing a database connection timeout with my SQLite connection, but I'm not sure how to bump up the connection timeout. The command timeout can be set with ConnectionString.DefaultTimeout but Connection.ConnectionTimout is read only. Any suggestions? Thanks, Brian ...