Ken,
I am not sure if this was suggested. I used this Perl project a while back
http://sourceforge.net/projects/mysitemaker/?abmode=1
It seems to meet all your needs.
regards,
./fxk
Casey: I think it's extremely hard to appreciate both the advantages
and disadvantages of a framework if you haven't done a bunch of stuff
both with and without one. ... Tim can be at least as productive
writing PHP by hand as I can using Django, but most of us can't be
Tim. Most of us need to
Define understand SQL. I can't help but be concerned about the adage
knows just enough to be dangerous. I've seen some systems brought to
their knees in terms of performance as a result of a couple of poorly
constructed queries.
The irony is that it's easy to do this in some simplified
On Wed, 30 Jul 2008, Tim Spalding wrote:
I'd consider teaching them how to use SQL directly.
I've done it at LibraryThing. I take employees from the simplest
SELECTs all the way to a people-who-have-X-also-have-Y self-join in
one long hands-on lesson. It doubles as a sort of test, and I've
The Django framework's Administration interface is pretty good for doing
quick database work, and it's highly customizable. It also does very basic
database introspection on existing databases to help get you set up.
-Andrew
On Wed, Jul 30, 2008 at 11:28 AM, Ken Irwin [EMAIL PROTECTED] wrote:
Hi All,
It ain't free, but there's a lovely client for mysql called navicat
(http://www.navicat.com/) that we've been using. And even though I *can*
do command line queries, gotta say I love pulling lines between tables to
set them up. It's not too expensive and I find that for light to
It bears repeating that many library standards, notably MARC, are
essentially non-relational and non-normalized. Fully normalized
relational databases aren't an obvious idea if you're never been
exposed to them—and something like a religious revelation once you
have. Whether or not SQL is a useful
We use an ODBC link as we can control the rights at the MySQL level like
Tobin mentions below
Susan
Tobin Cataldo wrote:
We have been using MS Access linked through MyODBC. The user's rights
are according to the permissions in the MySQL user table.
Tobin
Ken Irwin wrote:
Hi folks,
I
That's definitely true. One cartesian query can ruin your day...
On Thu, Jul 31, 2008 at 1:22 PM, John Fereira [EMAIL PROTECTED] wrote:
Tim Spalding wrote:
I'd consider teaching them how to use SQL directly.
I've done it at LibraryThing. I take employees from the simplest
SELECTs all the
Despite their repeated pleadings, I just can't afford to let my
colleagues learn SQL, Tim. I have to take every opportunity to hide the
knowledge from them. I've found that developing simple, easy-to-use
front-ends to complex internal systems here in the library is a good way
to keep them dumb
Hi folks,
I have some straightforward MySQL data tables that I would like to be
editable by some of my less-techy colleagues. I tend to think of
phpMyAdmin as a perfectly serviceable and reasonably interface for
updating database tables, but I'm told that it's kind of intimidating to
the
I was in a similar situation and I just used CodeIgniter's scaffolding
(http://codeigniter.com/user_guide/general/scaffolding.html ) feature to allow
my users to add/edit data. It's pretty safe, and it looks neat and clean, too.
Sean Hannan
Web Developer, Sheridan Libraries
Johns Hopkins
We have been using MS Access linked through MyODBC. The user's rights
are according to the permissions in the MySQL user table.
Tobin
Ken Irwin wrote:
Hi folks,
I have some straightforward MySQL data tables that I would like to be
editable by some of my less-techy colleagues. I tend to
I'd consider teaching them how to use SQL directly.
I've done it at LibraryThing. I take employees from the simplest
SELECTs all the way to a people-who-have-X-also-have-Y self-join in
one long hands-on lesson. It doubles as a sort of test, and I've even
used it in hiring. LibraryThing's two
, some framework is probably the way to go
for this, regardless of which you choose.
- David
-Original Message-
From: Code for Libraries on behalf of Ken Irwin
Sent: Wed 7/30/2008 6:35 AM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: [CODE4LIB] what's friendlier less powerful than phpMyAdmin?
Hi
Thanks for all the database suggestions. The Scaffolding function Sean
suggested is more perfect than I dreamed possible.
One day I'd probably benefit from learning the whole CodeIgniter
framework; for now, this function will do just what I need.
Thanks so much!
Ken
Sean Hannan wrote:
I was
for Libraries on behalf of Ken Irwin
Sent: Wed 7/30/2008 6:35 AM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: [CODE4LIB] what's friendlier less powerful than phpMyAdmin?
Hi folks,
I have some straightforward MySQL data tables that I would like to be
editable by some of my less-techy colleagues. I tend
less powerful than phpMyAdmin?
Hi folks,
I have some straightforward MySQL data tables that I would like to be
editable by some of my less-techy colleagues. I tend to think of
phpMyAdmin as a perfectly serviceable and reasonably interface for
updating database tables, but I'm told that it's
Shawn Boyette ☠ wrote:
I don't think he was asking about *programmers* creating or modifying *schema*.
It's true -- I just want a simple little data entry tool (which I've got
now! That was easy.)
I've been doing all of my development by hand, without the luxury of
frameworks, not out of
That reminds me of a better idea. Let's keep a real understanding of
computers from less-techy colleagues at the library. That way no
messy learning or understanding will take place, and we'll always be
needed.
Then we could start wearing white colors...
T
On Wed, Jul 30, 2008 at 11:43 AM, Alex
PROTECTED] On Behalf Of
Tim Spalding
Sent: Wednesday, July 30, 2008 8:49 AM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] what's friendlier less powerful than
phpMyAdmin?
That reminds me of a better idea. Let's keep a real understanding of
computers from less-techy colleagues at the library
21 matches
Mail list logo