Re: [CODE4LIB] [Web4lib] A million free covers, from LibraryThing

Thomas Dowling wrote: > Contrariwise, Wikipedia includes book and DVD covers and movie > posters, with a pretty verbose explanation of why they think > they're allowed to do so (see for example > ). > > I guess they just define th

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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:

Re: [CODE4LIB] what's friendlier & less powerful than phpMyAdmin?

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