Hi all, I am storing pages for websites in a 'pages' database table, they are referenced by their path (i.e. 'articles/my-first-blog-post'), I need to select all the children of a particular page, but without selecting grandchildren. So if I run: SELECT * FROM pages WHERE path LIKE 'articles%' I'll get pages with the following paths:...
I'm creating a database schema for storing historical stock data. I currently have a schema as show below. My requirements are to store "bar data" (date, open, high, low, close volume) for multiple stock symbols. Each symbol might also have multiple timeframes (e.g. Google Weekly bars and Google Daily bars). My current schema puts th...
Hi, Is there a light weight version of SQL Server I could use that has the characteristics of: Free (assuming my winforms app is semi-commercial) Can be seemlessly packaged for deployment as part of the winforms click-once application? (i.e. ease in installation for the user). Light weight for the user (ideally something that just ru...
Hi, I am using one simple code to access the SQLite database from Java application . My code is import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class ConnectSQLite { public static void main(String[] args) { Connection connection = null;...
How would I create a core-data application that syncs with a MySQL database? Should I implement a SQL-Lite layer and try to sync with MySQL that way? Or would running web services be better? I want to take advantage of Core Data modeling though. Is there any way to use Linq? I love linq. ...
I've got a mac application that I've developed. I use it to create sqlite files that are bundled with my iphone app. The mac app uses Core Data and bindings and is working fine except for one "weird" issue. I use an NSImageView (or Image Well) to allow me to drag and drop jpg files. This is bound through to an optional binary attribu...
I am working on a windows vista machine in python 3.1.1. I am trying to insert a large number of rows into a SQLite3 db. The file exists, and my program properly inserts some rows into the db. However, at some point in the insertion process, the program dies with this message: sqlite3.OperationalError: unable to open database file...
Background: Our C# application generates and executes queries to several types of databases (Oracle, SQL Server, MySQL), but a requirement came up to also apply them to a proprietary file format. The namespace used until now is System.Data.Common. The queries we need to apply are non-trivial (nested SELECTs, aliases in FROM, substring...
By design, Core Data does not issue a VACUUM SQL command to its SQLite database(s), as detailed here. I'm creating a Core Data application that'll store, and later delete, large binary files (2-10MB in size) in a SQLite db. Over time this will lead to fragmentation and a larger-than-necessary SQLite database. I'd like to periodically ...
How can I make some ful-text searching in non-english texts with sqlite? I use php5.3, with pdo_sqlite. CREATE VIRTUAL TABLE example USING FTS3(title TEXT, TOKENIZE icu hu_HU) This one is dont throw an Exception, but just a 0 byte length .sqlite file has been created. I dont see any virtual table. Below this link, i read that pdo_sqli...
I'm creating an SQLite file on the Mac using Core Data and then placing it in my iPhone app (GitHub project if curious). I want to release an update to the app with with an updated SQLite file. The model will be the same entities and attributes, there will just be more data. I run the app in simulator with the old sqlite file. Exit. Rep...
I am trying to display a large SQLite table in SWT. The problem is that SQLite's ResultSet does not support TYPE_SCROLL_INSENSITIVE which is needed when using the Listener approach. Is there a different approach for creating a virtual SWT table from an SQLite ResultSet? ...
in my program i have a database and two tables in it my first function readLocationsFromDatabase // Setup the database object sqlite3 *database; locations = [[NSMutableArray alloc] init]; // Open the database from the users filessytem if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { // Setup the ...
Hi, i have a problem that i can't solve ! (sqlite3, but i think it would be the same than MySql) I have those tables (image) : And i would like to find all the bus lines (with type and number) that go to two different streets from which i have the street_id (12 and 14 for exemple). The result shall give to the customer all of the bus...
Hi, Would be great to get some direction re trying to use sqlite for my WinForms application I'm building in VS2008. Installation - Is it just drop the "System.Data.SQLite.DLL" file into some folder in my VS2008 project (e.g. create a folder for it), and then create a "reference" to it? I've made the property of the reference CopyG...
Hi, I've got Sqlite working in a basic sense for my C# project in Visual Studio 2008 via use of the ADO.net Sqlite wrapper from http://sqlite.phxsoftware.com/. Question - For a C# winforms newbie what VS2008 data access layer approach would you recommend I look to use for my winforms app, as I need to write/read data from the sqlite da...
Any suggestions re best free (windows based) Sqlite management tool? ...
Hello world! I am a newbie to python but, believe me I have done a day of browsing to find an answer for this issue, :( The error message I am trying to get rid of is: AttributeError: 'sqlite3.Connection' object has no attribute 'enable_load_extension' I have 'easy_install'-ed the latest sqlite3 version and python somehow kno...
Hello: I have an extensive ASP.NET Sqlite driven application that will run through Apache with the help of Mono. For testing purposes, I created an application that has two textboxes and a button. When the textboxes are filled with text and the button is executed, a Sqlite table will receive the text within the textboxes. This test a...
I'm trying to view my firefox cookies db (cookies.sqlite). Since I've never accessed dbs with anything other than phpmyadmin, I'm at a loss as to how to view the content of this sqlite file. There's localhost/sqlitemanager, but I'd rather stick to the phpmyadmin interface that I'm used to. Any ideas how I can open/view this sqlite db th...