When writing my own flat file databases I try and keep the file sizes as small as possible, when designing mySQL databases I put all my tables into one database (I'm under the belief that mySQL stores each table in it's own file). I'm new to sqlite and my ethics clash - a whole database stored in one file. I know the recommended size is...
I am trying to compare the following values: gType = [[UILabel alloc]init]; if (gType = [NSString string:@"BUSINESS"]) { I get a warning that 'NSString' may not respond to '+string:' I am unsure what is wrong. gType is a value that I populate from a db query. Other text values from the same query show up fine in a UITableView, so...
Hi, I'm writing a web application in Rails which uses sqlite. I want the user to be able to search a table in the database by using a regex. Is this possible? Thanks. ...
Sqlite comes installed with OS X Developer Tools. What is the quickest/best way to upgrade or rebuild the default binary to support Sqlite's fulltext features? ...
Hey, I'm trying to run an NHibernate over sqlite. i have two projects: 1. Orange.Database - holds the pocos and daos and everything else 2. Orange.GUI - holds the gui... when the program reach to the reach the: Configuration config = new Configuration(); config.AddAssembly("Orange.Database"); sessionFactory = config.Configure().B...
I am trying to find some way to relate column types across the the most used Databases: MySQL, PostgreSQL, and SQLite. Here is what I have so far, but I'm afraid it's not done and I need some people with more experience to help me finish any missing types. MySQL PostgreSQL SQLite TINYINT SMA...
hi, I am working on a program that requires me to input values for 12 objects, each with 4 arrays, each with 100 values. (4800) values. The 4 arrays represent possible outcomes based on 2 boolean values... i.e. YY, YN, NN, NY and the 100 values to the array are what I want to extract based on another inputted variable. I previously ...
I am trying to retrieve a password from an SQLite database. The id of the row the password is in is 1. I want to assignt his password to a variable called actualpass. This is as far as I got before I became stuck. Can anyone help? Private Sub LoginButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LoginBut...
I an attempting to use a SQLiteFunction from my C# and ADO.NET code. Can anyone say why I get this problem? An unhandled exception of type 'System.Data.SQLite.SQLiteException' occurred in System.Data.SQLite.dll Additional information: SQLite error near "DEMOIT": syntax error I am using .NET 3.5 x86 with SQLite ADO.NET 1.0.65 - Help!...
Question: We've started a project for a customer, which includes what would normally be done with a database. However, the customer wants no database installed, since it's only a little application. We however intend to reuse the code for a larger project, which will use a database. The problem is all the server side code will be diffe...
Hi guys, I am having a strange error with VC# Express and System.Data.SQLite's Design-Time Database Explorer. You can see the error itself at http://tinypic.com/r/rcsl5g/6. What happens is, I go to Tools -> Connect to Database, select SQLite Database File, and then a window comes up with one place to enter a Connection String(you can see...
Here is an explanation of how the elements are related. tl;dr: Intensity is strongest at the center of the diagram. The basic emotions (in the arms) combine to form secondary emotions in the outer circle. (i.e., Anticipation + Joy = Optimism) What is the best way to design a database to model this set of relationships? ...
I am trying to write an app for a company that maintains a registry that is updated everyday. The app will have to take the user's location and display all the nearest locations that are in that registry. Thus far I have gotten the app to call out to google and get geocoding information for a small Plist that I came up with. However, con...
I am getting started with SubSonic. I wanted to change my db to sqlite and i have this in my config file <connectionStrings> <add name="NorthwindSQLite" connectionString="Data Source=C:\unzipped\WindowsFormsApplication1\my.db" providerName="System.Data.SQLite"/> </connectionStrings> I get the exception A first...
I need to have very fast access to a big Map - several millions of entries. Is it worth using an SQLite in-memory database to keep that map as opposed to just having that HashMap in memory? ...
hi all, i am new to iPhone. i want to ask that whether sqlite support the synchronization data with server database ...
I'm using the following for a LIKE query. Is this technique for LIKE correct? selectstmtSearch = nil; if(selectstmtSearch == nil){ const char *sql = "SELECT col1, col2 FROM table1 t1 JOIN table2 t2 ON t1.cityid = t2.cityid where t1.cityname like ?001 order by t1.cityname"; if(sqlite3_prepare_v2(databaseSearch, sql, -1, &selectstm...
Python --> SQLite --> ASP.NET C# I am looking for an in memory database application that does not have to write the data it receives to disc. Basically, I'll be having a Python server which receives gaming UDP data and translates the data and stores it in the memory database engine. I want to stay away from writing to disc as it takes ...
Similar to a feed reader, I'm storing a bunch of articles, each pertaining to a source (feed) and each feed can belong to a category. What I'm trying to do is: Retrieve the articles of the feeds that belong to a certain category. Group the articles. One scenario would be by date(published_time), so that I have groups, for example: (12....
I'm trying to create an SQLite 3 database from Python. I have a few types I'd like to insert into each record: A float, and then 3 groups of n floats, currently a tuple but could be an array or list.. I'm not well-enough versed in Python to understand all the differences. My problem is the INSERT statement. DAS = 12345 lats = (42,43,44,...