rdbms
Why are relational databases needed?
Specifically thinking of web apps, (1) why are relationships(ie:foreign keys) in RDBMS even useful? The web apps I write have logic built-in that validates user input against required fields. I see[详细]
2023-03-23 17:17 分类:问答PHP ORM with NOSQL and RDBMS support
Are there any PHP ORM projects which supports MySQL and NoSQL databases such as MongoDB? I am currently using RedBean to do MySQL ORM, however I woud like to introduce MongoDB to the applicatoin and[详细]
2023-03-22 01:02 分类:问答Basic set-based operations using a document database (noSQL)
As with most, I come from and RDMS world trying to get my head around noSQL databases and specifically document stores (as I find them the most interesting).[详细]
2023-03-20 11:03 分类:问答Standard use of 'Z' instead of NULL to represent missing data?
Outside of the argument of whether or not NULLs should ever be used: I am responsible for an existing database that uses NULL to mean "missing or never entered" data.It is different from emp[详细]
2023-03-19 07:27 分类:问答Is there any DBMS that does not rely upon SQL?
This topic is somewhat related to this question. There my answer was motivated by the assumption that SQL is necessary to access data in every database I know.[详细]
2023-03-19 00:45 分类:问答How to Deploy Database Changes to a Live Server?
I have a script that is part of my deployment process to pus开发者_如何学Ch DB changes to the production server. If the script corrupts my data for some reason (a bad update), it is tough to recover.[详细]
2023-03-18 12:14 分类:问答Embedded databases for ASP.NET
I need an embedded database solution that can be used from within an ASP.NET application. Unfortunately, it seems that SQL Server compact edition does not support ASP.NET and my web host does not avai[详细]
2023-03-17 03:57 分类:问答Can't decide database structure. Which one should i go for?
I\'m developing small application for a company. What they wa开发者_如何学运维nt me to do is some kind of event website which they can add participants for each event. My question is should I have one[详细]
2023-03-16 23:35 分类:问答Most efficient multi level commenting system
I\'m building a multi level commenting system and need a solution for quick reads and writes. I\'ve looked into adjacency list and nested set and it seems to me that for my particular scenario neithe[详细]
2023-03-15 05:15 分类:问答Is it ok to store postal addresses as one text field, rather than street1, street2, etc.?
I need to store postal addresses for my users, but I don\'t plan on really doing much with these addresses other than displaying it (won\'t be searching users by location or anything).In this scenario[详细]
2023-03-14 20:42 分类:问答