Hi, I'm hoping someone here might help me. The company I work for would prefer that I use MySQL instead of MSSQL. So I downloaded the latest driver (6.1) and am porting the DB layer. However I can not find the BeginExecuteReader function which takes a callback as parameter. Is this for a reason? Or does it work differently with MySQL...
I'm working on an online system that allows users to interact socially and of course it will be important to be able to identify users that are in fact online. I know about HTTP being stateless and I know about using sessions, so I'll need to accomplish this by comparing the last active time of a user to an arbitrary expiration time. M...
I am trying to secure a MSSQL database for our .Net website. I wanted to separate the database into different schemas so that we had an schema like 'Account' which had personal information and a schemas like 'Public' that had generic public content data. Each of these schemas would be accessed using different SQL user accounts and they...
I have a simple contest sign-up web form. Each contestant can check a box to be eligible to win one of 20 prizes. Upon submitting a form, a row is created in the "contestants" table. For each prize they have checked, a row in the "entries" table is created. I am trying to make a "results" page that lists all prize names, and below each ...
I'm trying to connect to derby using this: dbProperties.put("create", "true"); dbProperties.put("dataEncryption", "true"); dbProperties.put("encryptionAlgorithm", "DES/CBC/NoPadding"); dbProperties.put("encryptionKey", "1234567890123456"); dbProperties.put("securityMechanism", ClientDataSource.STRONG_PASSWORD_SUBSTITUTE_SECURITY); // p...
Hello, I've been unsuccessful in trying to find a US metropolitan area (e.x. San Francisco Bay Area, South Bay, The Berkshires, Upstate New York, etc.) database that is defined by cities. Does anyone know if such a thing exists? Wikipedia has a list of "Intrastate Regions" here: http://en.wikipedia.org/w/index.php?title=List_of_regio...
Hi all, I'm looking for best practices and ideas for managing data in a database table during a bulk data upload. I think it would be easiest to start with an example: Suppose the database table in question contains the following records: id | name | ... 1 | company A | 2 | company B | 3 | company C | I then opt to bulk upd...
Hi Everyone! I've looked around the Wordpress forums about this and didn't find anything so I thought I might try here. If you have a staging/dev Wordpress setup used for testing new pluging and such, how do you go about migrating the data in the staging database back to the production database? Is there a "Wordpress best practices" way...
As the title suggests, I like to show new products called in from specific categories separated by rows in the home page. Row 1 -> New products from Category 1 Row 2 -> New products from Category 2 Row 3 -> New products from Category 3 ...etc In my Magento Admin CMS, under Home Page they will be called in as separate...
How would one go about using a UUID as a primary key in an OpenOffice.org Base database? I have a need to gather data on multiple, unnetworked PCs that I can't install software on (I am using OpenOffice.org Portable). After gathering data, it will be merged into a single database. I believe that a UUID/GUID is the ideal solution, but f...
Does anyone know of a tool that can create a MS-Access database from a configuration file? It needs to be able to do things outside of the SQL spec such as be able to create macros, modules, and forms, and make changes to the "Lookup" tab that's available in Design View. And if possible, I need to be able to export an existing database ...
Our application isn't going to use rails for any part of its final state, but migrations are a fantastic way to define schema in my experience, so I'd like to use just that one aspect of rails. Is this a reasonable thing to do? If not, are there any tools out there than can be used to perform the same sort of job? We have a three-stag...
If MySQL databases with a MEMORY engine are stored in memory, does this mean that their contents are not persisted to disk? Or are they stored on HDD, but fully loaded into RAM on system power up? ...
When I'm writing scripts in PHP to work with MySQL databases with a MEMORY storage engine, is it as fast as PHP variables? Can I consider using such a database in place of some variables for buffers, message queues, etc? ...
When I run the following query in an iPhone app @"select name, identifier, score, delta from startups order by name ASC" I get the following error in my logs: sqlite error: no such column: score However, running pragma table_info(startups) in my sqlite3 database yields the following: sqlite> pragma table_info(startups); 0|id|INTEG...
I have a real time database which stores details of trouble tickets.I need to retrieve this information and build a dynamic XML based on it.Is it possible using EJB 2.0.? ...
In Drupal, if you want to insert something into the node table, 'nid' can be null, but 'vid' can't. The inverse is true for the node_revision table. So my question is, in what order are inserts done to the Drupal db when a node is created? i.e. I can't insert into the node table, because I don't have the VID, and I can't insert into th...
Hi, is there a way of automatic converting from array to Zend_Db_Table_Row or Zend_Db_Table_Rowset? Form Zend_Db_Table_Row you can get the array with toArray(), but I was wondering if there exits anything like opposite of that? Till now I have been implementing a function fill($data) which took the array and than set the atributes of Z...
Suppose you want to write into a database that something is 30 meters long, or 50 feet, or the temperature was 50 kelvin, the speed was 50 kilometers per hour. How would you represent the units ? To clarify, two points: any kind of units, not a predefined, well defined subset of them. my question is more relative to the existence o...
People seem to avoid building user interfaces that pull their information (names, field types, etc. as well as relationships) from a database; they instead hard-code forms (and tables, etc.) that have pretty much the same data names and types and things. Am I making sense? For instance, imagine an emumerated field in MySQL: why not jus...