Hello, does there exist a universal database backup/extract format? I'll explain where I'm coming from: our application supports several database vendors, DB2, MsSql, MySql and Oracle. Currently when we request a backup from a customer they must make a full backup in the vendor specific format. We have a small but powerful homegrown u...
RPM seems to be pretty good at checking dependencies and handling individual file updates, but what is the best practice for handling cumulative updates to, say, a relational database across multiple versions? For instance, say you have product Foo with versions 1.2.1, 1.2.2, 1.2.3, and 1.3.0. In each of these, there were database sche...
I'm interested in how database transactions "commonly" are implemented in a database system, like for instance MySQL. Assuming the actual writing of data to the physical database storage isn't an atomic operation (speaking in terms of clockcycles now), shouldn't I be able to corrupt a transaction by for instance ripping the power cable ...
I'm new to vb.net and having quite a challenge with updating a field in a table using the For...Next construct on a data set. Sample code below - can anyone tell me what I'm missing? I know this particular example could be accomplished with a simple SQL update statement, but the actual use for what this code will become requires steppi...
Hi, I have read lots of posts about the importance of database version control. However, I could not find a simple solution how to check if database is in state that it should be. For example, I have a databases with a table called "Version" (version number is being stored there). But database can be accessed and edited by developers ...
Anyone have any recommendations for books about performance tuning on either frontend or backend? I'm looking specifically for asp.net or sql (MS-SQL) performance tuning, but anything is good to go. Thanks! ...
I am taking a database class and have to draw a bunch of different kinds of diagrams. Specifically, I need to draw ERD and dependency diagrams. The instructor does not want any hand drawn diagrams but does not offer any clue as to what software to use. Does anybody have any suggestions? ...
I need to read floating point decimals from sqlite db I have created Variable type in database as INTEGER i am reading with sqlite3_column_int to NSInteger variables which parts should changed so i can read floating point integers from database thanks for answers sorry im a newbie in this topics ...
There's a gap in my SQL knowledge I'd like to fill and I'm after recommendations on where to find resources, eg. websites, how-tos, books, etc. I've been using SQL databases for a long time. I'm quite comfortable with: basic SQL and its syntax; creating tables and indexes; inserting data; and basic DBMS maintanenance. Where I struggle ...
For an enterprise application research project me and another person are working on, we are looking to remove certain content from the page to keep the posted messages universal(meaning not offensive and essentially anonymous). Right now we want to take a message that a user has posted to a message board, and remove any type of name, nam...
I found an interesting article at MSDN, which says: ADO makes it possible to treat an Excel workbook as if it were a database. So is it possible for an Excel workbook to connect to itself, and treat one of its worksheets as a database table and execute queries on it? -- and is this possible via VBA programming? ...
From time time to time my PostgreSQL DB is reporting a strange error: [client] postgres7 error: [-1: ERROR: invalid byte sequence for encoding \"UTF8\": 0xb4 HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by \"client_encoding\".] in adodb_throw(INSERT INT...
Hi, I have been working for a couple days trying to figure out how to do this. Working in C# I have a List of data being pulled from various database tables. I want to create different DropDownLists from this data that will persist across PostBacks. One way I was able to tinker through this was to parse the data into List> and nest t...
I've exported all the old orders out of our old store into a mySQL DB. Anyone know of a simple project or web based app that will let you search all fields with a wildcard? So if I type in sha automatically any results with those letters would popup. This would be similar to dbman but with mysql and some ajax. And preferably free and...
I am trying to decide whether to create a global view table or 1 for each section. for example, Lets say I have products, categories and pages. Do I have 3 tables e.g: CREATE TABLE `tbl_products` ( `p_id` INT NOT NULL , `p_views` INT NOT NULL , INDEX ( `p_id` ) ) ENGINE = MYISAM CREATE TABLE `tbl_categories` ( `c_id` INT NOT NULL , ...
I can't seem to execute SQL that creates a database using a DbCommand object. What am I doing wrong? Here's my code: DbConnection connection; // initialized and opened elsewhere DbCommand cmd = connection.CreateCommand(); cmd.CommandText = sql; cmd.ExecuteNonQuery(); Here's the error: The query syntax is not valid., near term ...
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 ...
I currently have a nested forms model. The nested forms for the paperclip attachments work fi and don't populate the DB with blanks, but another one I have for quotes always saves one blank quote along with my main model when I create a new one. How can I just have it silently fail and bypass writing this to the db? It's an optional fiel...
I know I can bind params in Kohana like this $this->db->query('SELECT * FROM products WHERE id = ?', array(14)); But is there a way to do it with identifiers (or whatever they are called?) As in $this->db->query('SELECT * FROM products WHERE id = :id', array(':id' => 14)); Thanks ...
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...