[Phpwiki-talk] databases, DB, classs, Emacs, oh my

[Steve W. <sw...@pa...>]

On Mon, 27 Aug 2001, Jeff Dairiki wrote:

> From what I can tell by reading postgres and miniSQL docs, my guess
> is that neither of those backends have the case-insensitivy problem
> (i.e. 'SandBox' and 'SanDbox' are truly different pages.)  Can you
> verify that that is the case?

Will do... Postgresql is good; I created "frontpage" and it's different
from FrontPage in the pagename column. I'll check mSQL next week.

> > What I'd like to set up is an automated test that I wrote on my last
[...]

> Yes, that would be good.  Also would be good to run an HTML validator
> automatically on all pages (or is that done by your test suite too?).

http-unit chokes on nonvalid HTML, and it's pretty strict.

> > Also, I still want to move to DB... perhaps I should just take a short cut
> > and write a db.php replica of mysql.php as a start. Writing the class and
> > changing all database calls is a lot of work...
>
> Should I work on "new" DB API (like I've been promising)?  Or are we
> happy with the hacks to the old API that Joel Uckelman has started?

We most definitely are moving to DB (and possible dbx for kicks, but I
doubt it... since we'll still have to support flat files and dbm). I've
committed the barest of class files to the tree already, so you may want
to start with that. I want to move one step at a time: devise the database
class, and integrate that into the code base. At that point we should do
an alpha release of 1.3. I would think:

1. Write the abstract base class (the interface definition)
2. Write a class that uses DB and extends the base class
3. Integrate that into the code base (basically, search and replace all
database calls)
4. Test, test, test.

The reason I stopped working on the abstract base class (aside from being
in Florida ;-) was I couldn't get Emacs to format the code according to
PEAR. I posted a question to gnu.emacs.help and got no answer, which is
odd.
<URL:http://groups.google.com/groups?q=group:gnu.emacs.help+author:swain%40panix.com&hl=en&safe=off&rnum=1&selm=9edb24c1.0106262044.62d055ce%40posting.google.com>

I've made three attempts to get Emacs to set c-basic-indent to four spaces
to no avail. Most irritating. I can do ESC-: and enter the setq by hand,
and it works; but I can't do it from .emacs or from the variables list
you inserted in the files.

~swain

---
                  http://www.panix.com/~swain/
"Without music to decorate it, time is just a bunch of boring
production deadlines or dates by which bills must be paid."
                     -- Frank Zappa
http://pgp.document_type.org:11371/pks/lookup?op=get&search=0xF7323BAC