Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Mitch Pirtle
On Wed, Feb 10, 2010 at 4:36 PM, Gary Mort wrote: > > > On Wed, Feb 10, 2010 at 12:40 PM, Justin Dearing > wrote: >> >> Now,with all that being said, If I were pre-dispositioned towards >> referential integrity and schema being handled in the app level (which I am >> not, big surprise), I'd use m

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Daniel Convissor
Hi Gary: MDB2 Schema is interesting stuff. I haven't used it myself. http://pear.php.net/package/MDB2_Schema/ --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.co

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 12:40 PM, Justin Dearing wrote: > > Now,with all that being said, If I were pre-dispositioned towards > referential integrity and schema being handled in the app level (which I am > not, big surprise), I'd use mongo for new developement. > Wow...longest thread on NYPHP to

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Ajai Khattri
On Wed, 10 Feb 2010, Gary Mort wrote: > If you avoid functions that are not cross platform > The benefit of XML or YAML would be that you can include those platform > specific features, and if your DB doesn't support it, it just ignores it and

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Justin Dearing
On Wed, Feb 10, 2010 at 12:12 PM, Gary Mort wrote: > > Keep in mind, most of that list is not available or not generally used in > MySQL 4.x > > Unfortunately, since most of the world is still MySQL 4, open source > projects have to code for that - so I tend to avoid special functions. > > Can y

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 11:50 AM, Justin Dearing wrote: > > > On Wed, Feb 10, 2010 at 11:09 AM, Gary Mort wrote: > >> >> Sure there is, it's called SQL. If you avoid functions that are not cross >> platform, it's fairly easy to take SQL database creation scripts in one >> platform and import the

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Justin Dearing
On Wed, Feb 10, 2010 at 10:23 AM, Gary Mort wrote: > > > On Wed, Feb 10, 2010 at 9:11 AM, Justin Dearing wrote: > >> >>> >> Just a few notes. Ken has stopped maintaining and using Andromeda. >> > > > Hmm, any idea why? I could never get into it because I work for clients in > shared hosting aka

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Justin Dearing
On Wed, Feb 10, 2010 at 11:09 AM, Gary Mort wrote: > > > On Wed, Feb 10, 2010 at 10:58 AM, Ajai Khattri wrote: > >> There is no standard for defining how to describe databases. YAML is >> simply a convenient format for use in config files for any >> language/framework). >> >> >> Sure there is,

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 10:58 AM, Ajai Khattri wrote: > On Wed, 10 Feb 2010, Gary Mort wrote: > > Oh well, score 0 for cross platform/language coolness. > > There is no standard for defining how to describe databases. YAML is > simply a convenient format for use in config files for any > language

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 10:47 AM, Ajai Khattri wrote: > On Wed, 10 Feb 2010, Gary Mort wrote: > > > So now I'm wondering is YAML used in such a manner and is there a > standard > > definition for how to use YAML, or is both Doctrine and Andromeda simply > > rolling their own systems? > > YAML has

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Ajai Khattri
On Wed, 10 Feb 2010, Gary Mort wrote: > There are some similar things for Ruby, such as > http://rubyforge.org/projects/db-discovery/ but the more digging I do, the > only "standardized" items I find are config files[database name, server, > username, password] not DDL Yes, YAML is used in Rails

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Ajai Khattri
On Wed, 10 Feb 2010, Gary Mort wrote: > So now I'm wondering is YAML used in such a manner and is there a standard > definition for how to use YAML, or is both Doctrine and Andromeda simply > rolling their own systems? YAML has standard ways to describe key-value pairs, lists, etc, but each appl

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 9:11 AM, Justin Dearing wrote: > >> > Just a few notes. Ken has stopped maintaining and using Andromeda. > Hmm, any idea why? I could never get into it because I work for clients in shared hosting aka mysql environments but he was really gung ho for a while. > Donald

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Justin Dearing
On Wed, Feb 10, 2010 at 8:40 AM, Gary Mort wrote: > > But the idea that if he stores definitions in YAML programmers can use them > interested him enough to learn something newso now I want to find what > the standards for defining database structure in YAML is...or if there are > none, then

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
On Wed, Feb 10, 2010 at 8:12 AM, Chris Snyder wrote: > On Wed, Feb 10, 2010 at 7:42 AM, Gary Mort wrote: > > > So now I'm wondering is YAML used in such a manner and is there a > standard > > definition for how to use YAML, or is both Doctrine and Andromeda simply > > rolling their own systems?

Re: [nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Chris Snyder
On Wed, Feb 10, 2010 at 7:42 AM, Gary Mort wrote: > So now I'm wondering is YAML used in such a manner and is there a standard > definition for how to use YAML, or is both Doctrine and Andromeda simply > rolling their own systems?  I don't want to point him to the main YAML site, > because frankl

[nyphp-talk] YAML and Database Definitions

2010-02-10 Thread Gary Mort
Both Doctrine and Andromeda use YAML files to describe the database[tables, columns, etc]. I had assumed[bad idea] that meant that YAML was widely used in that regard and there was a standardized YAML definition for database definitions. Now I'm in a bindsince I was talking to my father about