Ok, inspired in part by CakePHP's Model Validation I created a project which uses a separate database schema file. I didn't like that in CakePHP the model file and the db-schema are combined in the same php file. I like having them separate. All of my sql updates, inserts, and deletes are first passed by this schema. I wrote update() in...
Hey everyone, I am in a Software Engineering Master's program, and I have to start my thesis work pretty soon. I understand that ultimately, the decision on what I do has to be up to me, but I was hoping to try and get a couple ideas. My advisor was right in telling me that the hardest part is coming up with a good idea. The requiremen...
I am trying to merge three fields in each line of a CSV file using Python. This would be simple, except some of the fields are surrounded by double quotes and include commas. Here is an example: ,,Joe,Smith,New Haven,CT,"Moved from Portland, CT",,goo, Is there a simple algorithm that could merge fields 7-9 for each line in this format...
As the title asks, is VistaDB 3.x/4.x supported in Data Access Application Block (DAAB) of Microsoft Patterns and Practices Enterprise Library 3.x/4.x? If it is and you have used the two together, are there any issues or caveats I should know about? Or... Could anybody provide links to source code for the custom provider for Enterprise...
Hi, Has anyone had experience writing a game engine or demo engine using something like a SQL database to store game assets? Does it make sense to use in that context? What would be the advantages and disadvantages? Thanks! ...
I am using SQL Server 2008 express edition but I want to make my databases still in 2005. How can I set it up to only show features that a 2005 database can use? Like for instance I don't remember there being a "date" type. I only remember "dateTime". I don't want to be using features that 2005 can't support and I later on upload my db...
I write an application for drawing shops. I have these classes in my system: shop, cart place, rack and bakery. They have this properties: shop: X, Y, name, width, height, type, address cart place: X, Y, name, width, length, type, capacity rack: X, Y, name, width, length, type, height, balance_limit bakery: X, Y, name, width, leng...
Hey guys, Has anyone used Tokyo Cabinet on the iPhone? I'm interested to see if there are any real world performance differences between it and SQLite3. Also, SQLite 3 has the expressive power of SQL, does Tokyo Cabinet have any kind of query language? Any input would be greatly appreciated, thanks. ...
How do I convert hexadecimal to decimal (and back again) using Oracle SQL? ...
I have a situation where I need to store a general piece of data (could be an int, float, or string) in my database, but I don't know ahead of time which it will be. I need a table (or less preferably tables) to store this unknown typed data. What I think I am going to do is have a column for each data type, only use one for each record...
I have an app that is running in the simulator. I read and write from a sqlite3 data source. However, if i restart the app, then all datg that i had previously wrote to the db is lost. The data is always in its original state. Now back when i was developing this app i thought i read somewhere that data can not be persisted via iphone si...
I was wondering if anyone can give me a link on following a best practice pattern for inserting data in a SQL db using stored procedures. I mean, what procedures should we take to ensure validated data to be passed through stored procedures. ...
A Microsoft Access implementation is throwing a type mismatch error while trying to execute a macro that opens up some queries. Most of the tables are linked to a SQL Server and I need to join two of the tables together that have different datatypes. Table A: REFERENCE TEXT Table B: REFNO NUMBER I would ordinarily want to correct the...
I am simply trying to convert a table from MyISAM to INNODB. This is for a bugzilla upgrade with testopia. This simple command fails. ALTER TABLE table_name TYPE = INNODB; ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes I know it does not support FULLTEXT indexes, never the less I want it to convert. Would I h...
There's a healthy debate out there between surrogate and natural keys: SO Post 1 SO Post 2 My opinion, which seems to be in line with the majority (it's a slim majority), is that you should use surrogate keys unless a natural key is completely obvious and guaranteed not to change. Then you should enforce uniqueness on the natural key...
Hi! I hope someone can help me with the following: I need to know if it is possible to implement a trigger that monitors the value of an specific field, and when it changes the value, it should update the value of another field in another table. ...
Hello, I am interested is NVarchar(MAX) a good data type is I want to store short unicode strings which are 1-50 characters long, but most of them (more than 90%) are 5-10 characters long? The column will not be used in comparison and ordering queries. It might be added to index as included column. Expected rows count - more than 10M. ...
Is it a "legit" programming practice to consider directory structure as a database? A hierarchical database. User has access to the database through Windows explorer. Would it be reasonable to tell a user that he should "give" data to the program by organizing his folders in "x" fashion? Are there examples of software that do this ef...
I know that it is a databases in Palm OS, as the development is shift to webOS. Is there any third party javascript library to do the work? or it needs to write manually? ...
How does ORM work? Are objects serialized into BLOBs? In Java, is JDO still the way to go for this? What else is available? Seems like there was a lot of talk of EJB, direct object serialization, and JDO. ...