Re: Need a CRUD thing
On 25/08/2010 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. If only there were a web application framework in Perl that's really simple to use and comes with a nice set of built-in CRUD templates. Nope, can't think of anything. Simon
Re: Need a CRUD thing
On Sat, 2010-08-28 at 09:22 +0100, Simon Cozens wrote: If only there were a web application framework in Perl that's really simple to use and comes with a nice set of built-in CRUD templates. Nope, can't think of anything. Wow, you should write one of those. There may even be people out there who would use it to do things like tracking their drinking experiences.
Re: Need a CRUD thing
On 26/08/2010, at 12:59 AM, Dagfinn Ilmari Mannsåker wrote: David Cantrell da...@cantrell.org.uk writes: On Wed, Aug 25, 2010 at 03:12:29PM +0100, Tom Hukins wrote: Oh look, I misunderstood the question and made a fool of myself on the list. But it's also not a tiny script as it has lots of dependencies. Dependencies I don't care about - the computer can take care of those for me. I just don't want to have to write any code to glue all the dependencies together. So, provided that it's CGI-friendly, AutoCRUD looks like a good candidate. You _really_ don't want to run Catalyst (especially not 5.80 with all the Moose stuff) without a persistent process model. Doubly so if you're using DBIx::Class::Schema::Loader in dynamic mode, like you indicated you'd like to in another post. Don't run Catalyst under CGI. However if it's your own web server, rather than crappy shared hosting it's trivial to run the catalyst dev server (maybe using Catalyst::Engine::HTTP::Prefork[1]) and reverse proxying it to your web server. If it's crappy shared hosting, use phpmyadmin instead (or work out how to configure fastcgi) [1] Yes, I know there are newer, sexier plackier ways of running a catalyst app, but this wfm.
Need a CRUD thing
Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. I really can't be arsed with dicking about with appeasing DBIx::Class and Catalyst by hand. Bonus points if it works with SQLite. Brickbats if it requires mod_perl or similar or Java. -- David Cantrell | Enforcer, South London Linguistic Massive Did you know that shotguns taste like candy canes? Put the barrel in your mouth and pull the trigger for an extra blast of minty goodness!
Re: Need a CRUD thing
On 25 Aug 2010, at 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. A while back I would have pointed you to CatalystX::ListFramework::Builder However I see it has now been deprecated in favour of Catalyst::Plugin::AutoCRUD Nigel. -- [ Nigel Metheringham nigel.methering...@intechnology.com ] [ - Comments in this message are my own and not ITO opinion/policy - ]
Re: Need a CRUD thing
On 25 Aug 2010, at 14:28, David Cantrell wrote: Bonus points if it works with SQLite. Brickbats if it requires mod_perl or similar or Java. Ruby? :) -- Andy Armstrong, Hexten
Re: Need a CRUD thing
On Wed, 2010-08-25 at 14:40 +0100, Nigel Metheringham wrote: On 25 Aug 2010, at 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. A while back I would have pointed you to CatalystX::ListFramework::Builder However I see it has now been deprecated in favour of Catalyst::Plugin::AutoCRUD I've used AutoCRUD. It's quick and easy to use, and as a bonus the author is responsive to bug reports (I found some quirks, I don't think normal use would). signature.asc Description: This is a digitally signed message part
Re: Need a CRUD thing
http://search.cpan.org/perldoc?Catalyst::Plugin::AutoCRUD Originated from a beastie we wrote to do Cat + extjs for recruitment software using web browsers, CatalystX::ListFramework Regards, Peter http://perl.dragonstaff.co.uk On Aug 25, 2010 2:34 PM, David Cantrell da...@cantrell.org.uk wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. I really can't be arsed with dicking about with appeasing DBIx::Class and Catalyst by hand. Bonus points if it works with SQLite. Brickbats if it requires mod_perl or similar or Java. -- David Cantrell | Enforcer, South London Linguistic Massive Did you know that shotguns taste like candy canes? Put the barrel in your mouth and pull the trigger for an extra blast of minty goodness!
Re: Need a CRUD thing
On Wed, Aug 25, 2010 at 02:40:57PM +0100, Nigel Metheringham wrote: On 25 Aug 2010, at 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. CGI/DBI. Job done. m. -- http://weblog.straytoaster.co.uk/ # Gotta have a weblog. It is the law. http://www.flickr.com/photos/straytoaster # All the cool kids have photostreams http://www.myspace.com/thirtyspokes # talent not included
Re: Need a CRUD thing
On 25/08/2010 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. Bonus points if it works with SQLite. phpSQLiteAdmin ? http://phpsqliteadmin.sourceforge.net/index.php S.
Re: Need a CRUD thing
On Wed, Aug 25, 2010 at 02:40:57PM +0100, Nigel Metheringham wrote: On 25 Aug 2010, at 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. A while back I would have pointed you to CatalystX::ListFramework::Builder However I see it has now been deprecated in favour of Catalyst::Plugin::AutoCRUD Oliver renamed LFB to AutoCRUD in the hope that the new name would describe what it does better. While I like it lots, I don't believe it will help Dave as it's not easily scriptable. Someone sufficiently sick might script it using something like WWW::Mechanize::Firefox, or maybe even Mechanical Turk, but I would never dream of considering Dave as such a person.. Tom
Re: Need a CRUD thing
On Wed, Aug 25, 2010 at 03:00:35PM +0100, Tom Hukins wrote: On Wed, Aug 25, 2010 at 02:40:57PM +0100, Nigel Metheringham wrote: On 25 Aug 2010, at 14:28, David Cantrell wrote: Dear interwebs, please point me at a Thingy which will allow me to point a tiny script at a database and have it do CRUDdy web stuff. A while back I would have pointed you to CatalystX::ListFramework::Builder However I see it has now been deprecated in favour of Catalyst::Plugin::AutoCRUD While I like it lots, I don't believe it will help Dave as it's not easily scriptable. Oh look, I misunderstood the question and made a fool of myself on the list. But it's also not a tiny script as it has lots of dependencies. Tom
Re: Need a CRUD thing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 25/08/2010 15:12, Tom Hukins wrote: On Wed, Aug 25, 2010 at 03:00:35PM +0100, Tom Hukins wrote: While I like it lots, I don't believe it will help Dave as it's not easily scriptable. But you did remind me of a long ago idea to implement a CLI one-liner version which would take params such as listening port and DB connection settings, and start up the app. - -- Oliver Gorwits, Network and Telecommunications Group, Oxford University Computing Services -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkx1KD0ACgkQ2NPq7pwWBt5p7wCg9ItIwuUkEnALKeqkq225d2j9 AUQAn0RosXa7AoxyhddSCYPYbTKmm1dw =AIUk -END PGP SIGNATURE-
Re: Need a CRUD thing
On Wed, Aug 25, 2010 at 03:12:29PM +0100, Tom Hukins wrote: Oh look, I misunderstood the question and made a fool of myself on the list. But it's also not a tiny script as it has lots of dependencies. Dependencies I don't care about - the computer can take care of those for me. I just don't want to have to write any code to glue all the dependencies together. So, provided that it's CGI-friendly, AutoCRUD looks like a good candidate. -- David Cantrell | London Perl Mongers Deputy Chief Heretic Planckton: n, the smallest possible living thing
Re: Need a CRUD thing
On Wed, Aug 25, 2010 at 03:27:09PM +0100, Oliver Gorwits wrote: But you did remind me of a long ago idea to implement a CLI one-liner version which would take params such as listening port and DB connection settings, and start up the app. What would be awesome would be if I could have a script get invoked as a CGI which just reads something like ... #!/usr/local/bin/perl use Catalyst::AutoCRUD dsn = dbi:... and have it automagically work out absolutely everything, including all the relationships between tables. It looks like the demo app is almost there already. -- David Cantrell | Hero of the Information Age Irregular English: you have anecdotes; they have data; I have proof
Re: Need a CRUD thing
David Cantrell da...@cantrell.org.uk writes: On Wed, Aug 25, 2010 at 03:12:29PM +0100, Tom Hukins wrote: Oh look, I misunderstood the question and made a fool of myself on the list. But it's also not a tiny script as it has lots of dependencies. Dependencies I don't care about - the computer can take care of those for me. I just don't want to have to write any code to glue all the dependencies together. So, provided that it's CGI-friendly, AutoCRUD looks like a good candidate. You _really_ don't want to run Catalyst (especially not 5.80 with all the Moose stuff) without a persistent process model. Doubly so if you're using DBIx::Class::Schema::Loader in dynamic mode, like you indicated you'd like to in another post. -- ilmari A disappointingly low fraction of the human race is, at any given time, on fire. - Stig Sandbeck Mathisen
