PHP London PubCon

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

PHP London PubCon

Post by Ollie Saunders »

I was at the PHP London PubCon today. Basically 30 geeks packed into a room in a small pub talking about PHP.
I met this one particular guy Richard. He was talking about a framework he had written that used PDO as a database abstraction layer.

He could create entire forms by creating a very short (20 line class) extending upon lets say class A. Class A (calling upon lots of other stuff) would be able to query metadata from a table (using SHOW FULL COLUMNS) and generate applicable forms from them using the SQL COMMENTs as form labels. It would recognise foreign keys to other tables and then generate AJAX code that would allow fields to be created where the user can pick a value from another table. I think it automated quite a lot of validation too.

There was loads of other stuff he was talking about too, really impressive.
Just thought I'd share.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Why is this in Theory?
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Where should I put it?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Unless you have a real reason for it being in Theory, I will move it to General Discussion.
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Well its about a framework design.
User avatar
Todd_Z
Forum Regular
Posts: 708
Joined: Thu Nov 25, 2004 9:53 pm
Location: U Michigan

Post by Todd_Z »

Try to recruit him to phpDN! That is exactly the kind of system that I'm looking to create.
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

Yeah, this guy earns way too much money to care about dev net and its a private system and he wouldn't listen to me.
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Post by alex.barylski »

That would be a sad attitude...

Regardless of income or importqance in programming circles...even the most experienced and advanced developer can learn something from a online community like this...

IMHO anyways...
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

Hockey wrote:That would be a sad attitude...

Regardless of income or importqance in programming circles...even the most experienced and advanced developer can learn something from a online community like this...

IMHO anyways...
Besides, that's like geo metro owners putting down others because their metro is faster.

I mean.. we're programmers.. we're the ones who are supposed to be getting put down by others, not each other! :lol:
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

lol

nice analogy
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: PHP London PubCon

Post by Benjamin »

ole wrote:He could create entire forms by creating a very short (20 line class) extending upon lets say class A. Class A (calling upon lots of other stuff) would be able to query metadata from a table (using SHOW FULL COLUMNS) and generate applicable forms from them using the SQL COMMENTs as form labels. It would recognise foreign keys to other tables and then generate AJAX code that would allow fields to be created where the user can pick a value from another table. I think it automated quite a lot of validation too.
That sounds really nice because it would create a robust way to quickly build forms and it would speed up development. I've been thinking about building something like this for some time. I'm going to start on it pretty soon. I'm not sure I blame him for not sharing. That is a pretty powerfull bit of code he's got there. It makes him very valuable when he can build something 5-10 times faster than other developers and do a better job at the same time.
GM
Forum Contributor
Posts: 365
Joined: Wed Apr 26, 2006 4:19 am
Location: Italy

Re: PHP London PubCon

Post by GM »

ole wrote:I was at the PHP London PubCon today. Basically 30 geeks packed into a room in a small pub talking about PHP.
I met this one particular guy Richard. He was talking about a framework he had written that used PDO as a database abstraction layer.

He could create entire forms by creating a very short (20 line class) extending upon lets say class A. Class A (calling upon lots of other stuff) would be able to query metadata from a table (using SHOW FULL COLUMNS) and generate applicable forms from them using the SQL COMMENTs as form labels. It would recognise foreign keys to other tables and then generate AJAX code that would allow fields to be created where the user can pick a value from another table. I think it automated quite a lot of validation too.

There was loads of other stuff he was talking about too, really impressive.
Just thought I'd share.
Mine does something similar to that (apart from the AJAX bit, which mine doesn't do - I pass the sql fragments in the field constructor), and it writes Javascript form validation too, based on the metadata from the tables. It's also used as the first line back-end validation.
User avatar
panic!
Forum Regular
Posts: 516
Joined: Mon Jul 31, 2006 7:59 am
Location: Brighton, UK

Post by panic! »

Sounds very much like Ruby on Rails' Scaffolding feature to me, not that that's a bad thing!
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Post by Ollie Saunders »

GM wrote:Sounds very much like Ruby on Rails' Scaffolding feature to me, not that that's a bad thing!
Reminded me of Access actually (if any of you have had the misfortune of using that).
Hockey wrote:Regardless of income or importqance in programming circles...even the most experienced and advanced developer can learn something from a online community like this...
Well that's a nice thought. Not sure if its true. I know Richard wouldn't think so.
astions wrote:That sounds really nice because it would create a robust way to quickly build forms and it would speed up development.
Yes it does speed up development up by a smurf loads. I forgot to ask him about performance because if you have to get a load of meta data from the database for each request its going to slow stuff down quite a bit. UNLESS, he's implemented some kind of cacheing mechanism which I think would be essenuial.

Also what is happening here is really only a generified (is that a word?) solution to a technical problem, i.e. a lot of abstract code has been given all the power to manage every single aspect of a form, presentation, validation, db insertion etc. So unless it has be designed in a way where by everything can be overloaded and tweaked in a more manual fashion you aren't going to achieve a great deal o fuser friendlyness. Someone who programs a form themselves by hand will be able to get be really specific about all the minor details and create something with absolute suitability.

Anyway he works for what seems like a great company called The Mind Gym and I think I found one of the forms in question.
Grim...
DevNet Resident
Posts: 1445
Joined: Tue May 18, 2004 5:32 am
Location: London, UK

Post by Grim... »

Erm... Excuse me?
Why wasn't I invited?

:(
Post Reply