Path: csiph.com!usenet.pasdenom.info!news.albasani.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Peter H. Coffin" Newsgroups: comp.lang.php Subject: Re: Nested PHP Date: Mon, 17 Mar 2014 17:10:51 -0500 Lines: 31 Message-ID: References: <1lgvceg.n1ow4ilfgsk0N%adrian@poppyrecords.invalid.invalid> <5313461D.70508@arnowelzel.de> <5327062C.6010706@arnowelzel.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: individual.net /6Hfe351LrTUx7DVaC0DQw/hfEZPis33ZYwWeCgpz6/lbiY5Ak X-Orig-Path: nibelheim.ninehells.com!_news Cancel-Lock: sha1:cub5lMFpnF5qE5W/H8Xfh8trb/s= User-Agent: slrn/0.9.9p1 (OpenBSD) Xref: csiph.com comp.lang.php:13203 On Mon, 17 Mar 2014 15:33:13 +0000, The Natural Philosopher wrote: > What does a data base do well? > - breaks the directory hierarchy of data > - moves the data outside of the actual era directly accessible to te web > server > - provides a one point of backup > - adds a security of access to the data and code not easily done in > other ways. Oh dear... Let's start with that SQL was developed to run on a machine that had no directory hierarchy, had no web, didn't even really have a concept of "file" that was distinct from "table", and backing stuff up was a matter of "saving things", because you had no idea whether something was in memory or disk and didn't care. The security wasn't added on because the whole OS was pretty indistinguishable from the database. Everything you've mentioned is a side-effect of the database, not intrinsic to its use. You wanna run at this again? Nevermind, I'll just tell you. A database allows you to separate data from application in a way that allows you to change the data, including its interdependant relationships and qualities, without necessarily changing the application. The data comes first. Anytime you're starting with the application first, you're working not with a database, but rather with a "storage subsystem". Which is all fine and dandy, but it slaps you with richard problems forever, in varying severity, until you give up, start over with the data, and do it right. -- 34. I will not turn into a snake. It never helps. --Peter Anspach's list of things to do as an Evil Overlord