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
In addition to initial productivity, maintainability and enhanceability,
including by future people who won't be you, is a huge consideration.
A framework can probably either help or hurt that too, depending on how
good it is.
Jonathan
Tim Spalding wrote:
Casey: "I think it's extremely hard
On Mon, Aug 11, 2008 at 7:02 PM, Tim Spalding <[EMAIL PROTECTED]> wrote:
> I see errors in both directions. There are some CRUD pieces to
> LibraryThing that took *way* too much time to do because we did them
> all by hand. Casey's introduction of a Django framework there was very
> smart. At the s
> > 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
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
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
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
>> SELECT
John Fereira wrote:
Tim Spalding wrote:
I think there's a real opportunity for empowerment here. Teach a man
to SELECT and he'll never have to, um, fish again.
Define "understand SQL". I can't help but be concerned about the
adage "knows just enough to be dangerous". I've seen some systems
b
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 have
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
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. If you want to be a great developer you do need to know
how to do stuff at a low level, no question. But for most developers and
most proj
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 medi
Sounds like you have what you need, but if you don't want to deal with a
framework, you might look into phpmyedit. It's a small program that you
can attach to a table for quick and configurable CRUD functionality for
the data in the table. It has a utility that generates the basic code
you need
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:
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 even
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 even
used it in hiring. Li
On Jul 30, 2008, at 1:47 PM, Cloutman, David wrote:
Perhaps you should put together some MySQL training materials for
librarians. A webinar, perhaps. I'd love it if my colleagues had those
skills. I don't think there is that much interest, but I could be
wrong.
There are at least 101 ways ent
raries [mailto:[EMAIL 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
8:07 AM
To: CODE4LIB@LISTSERV.ND.EDU
Subject: Re: [CODE4LIB] what's friendlier & less powerful than
phpMyAdmin?
This gets religious quickly, but, in my experience, programmers who
learn on a framework miss out on their understanding of database
necessities. They may not matter much when
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, Ale
That reminds me of an idea for a photo sharing website I had,
tentatively called LeftOutrJoinr. It would be like Flickr, but instead
of pictures everywhere, visitors would be given a command line into
which they would be able to enter their own SQL queries to call up
photos to appear on the pag
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 an
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 phpMyA
e.
>
> - 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 folks,
>
> I have s
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 i
eally, 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 ph
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 full-
Safe? H. I'll have to check it out.
- Gavin
>>> Sean Hannan <[EMAIL PROTECTED]> 07/30/08 6:46 AM >>>
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
I use Webmin. http://www.webmin.com/
It gives me a GUI for all of my vital sysadmin needs that I can't
remember how to do at the shell.
It has a MySQL GUI interface that works very well. And you can setup
user accounts to have access to certain parts of Webmin, like just MySQL.
Easy RPM in
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 thin
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 Univer
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 unin
32 matches
Mail list logo
