Search Results

Preferably with MySQL compatibility. I am guessing that xml, a udf or stored procedure might be necessary. is there a way to use xml or json directly in sql/mysql? Thanks! …

These are the options I've thought of: DotNet Dave: UPDATE mytable set f1=newval where id=666 and f1 := f1ValueFromSelect Charlie Checksum: UPDATE mytable set f1=newval where id=666 and md5(c …

If you don't need to sort or search features, then using a CLOB might be fine, storing all the features as XML, which you can still query and is easy to format to HTML. If there are business rules or …

You could use Nested Set, but CRUD operations are more complex than other patterns, and there's no referential integrity. The Closure Table pattern is simpler to CRUD and supports integrity, but requ …

Make one table for all surveys. Don't make a new table for each survey. Also, make sure you hash and salt your passwords with bcrypt.

--this is postgres syntax, but similar for mysql --using single table inheritance for simplicity --organizations (o) and individuals (i) go here: create table parties ( party_id int primary key, …

I think you're on the right track. You are using Single Table Inheritance (STI) appropriately here. You could say that a Category is a sub-type of Tag. Categories extend Tag by having a possible pare …

Don't use EAV. There's no integrity and it's hard to query. Your best bet is either to simply change the database schema, or to use LOB fields, such as XML or JSON. These are what Martin Fowler recom …

There is some redundancy in your design. If you think of a condo building and condo unit as different types of facilities, then you can put them in one table, like this: create table facilities ( …

A good start. use InnoDB (or better yet, Postgres). You can use MyISAM slaves if you want full-text search, but otherwise, foreign keys are your friends. watch your under_scores and camelCase. Use l …

You should consider Postgres, as it does hierarchical querying better than Mysql. If using Mysql, consider using a closure table to aid querying. …

good lord, no. read up on multi-tenancy http://msdn.microsoft.com/en-us/library/aa479086.aspx read up on the Party Model http://www.tdan.com/view-articles/5014/ read up on Table Inheritance http:// …

You can use the default keyword instead of null: create table foo ( id int not null AUTO_INCREMENT, name varchar(255), primary key (id) ); insert into foo values (default, 'john doe'); selec …

A foreign key means "ensure the values in this column exist in another column" For example create table sales_orders ( order_id int primary key, customer_id int, ... ); If customer_id does n …

Because MySQL is not as mature. … But there are options, such as Percona's (free) hot backup for innodb: http://www.percona.com/software/percona-xtrabackup/ There is also MySQL Enterprise Backup from Oracle, but it is not free. …