FacebookTwitter
Hatrack River Forum   
my profile login | search | faq | forum home

  next oldest topic   next newest topic
» Hatrack River Forum » Active Forums » Books, Films, Food and Culture » A Technical Database Question

   
Author Topic: A Technical Database Question
WheatPuppet
Member
Member # 5142

 - posted      Profile for WheatPuppet   Email WheatPuppet         Edit/Delete Post 
I've been lurking for a number of months. I've been up to a bunch of things, and I don't have time for a fast-moving forum.

Anyway, I'm trying to set up a web page, and I want an easy way of storing content independently of design using PHP. The logical thing to do would be to use a database. The problem is, I don't have access to one, and I don't have admin privlages to install my own. Do any of the technical-minded folks here know of a way to have the functionality of a database without the administrative overhead?

I've tried coding my own lightweight flatfile database, and decided that it required far too much mucking around with PHP (an ugly language, IMO) to be worth it.

~Nick

Posts: 903 | Registered: May 2003  |  IP: Logged | Report this post to a Moderator
fugu13
Member
Member # 2859

 - posted      Profile for fugu13   Email fugu13         Edit/Delete Post 
I would be surprised if your ISP didn't at least have BDB installed and support for it compiled into PHP.

BDB is the Berkely Database, its flatfile based, and only really stores key-value pairs, but it has an ACID compliant version. And heck, its fast enough that even if you have to get a write lock every time you write (multiple readers are fine even on the non-transactional version), you'd prolly still be okay.

Posts: 15770 | Registered: Dec 2001  |  IP: Logged | Report this post to a Moderator
TMedina
Member
Member # 6649

 - posted      Profile for TMedina   Email TMedina         Edit/Delete Post 
I believe MySQL is free and relatively simple to use.

It's next on my software project list.

-Trevor

Posts: 5413 | Registered: Jun 2004  |  IP: Logged | Report this post to a Moderator
fugu13
Member
Member # 2859

 - posted      Profile for fugu13   Email fugu13         Edit/Delete Post 
Psst, TM:

quote:
The problem is, I don't have access to one, and I don't have admin privlages to install my own.
And if you're going to learn an open source database, for the sake of the children learn PostgreSQL. For all its improvements in recent years, MySQL is still a database ill-suited to many database tasks, and definitely ill-suited to learning how databases work (as there aren't any other databases that work like it).

PostgreSQL is a much closer experience to working with an industrial DB, because it is an industrial DB.

[ March 09, 2005, 10:35 AM: Message edited by: fugu13 ]

Posts: 15770 | Registered: Dec 2001  |  IP: Logged | Report this post to a Moderator
TMedina
Member
Member # 6649

 - posted      Profile for TMedina   Email TMedina         Edit/Delete Post 
I blame the cough medicine. [Razz]

-Trevor

Posts: 5413 | Registered: Jun 2004  |  IP: Logged | Report this post to a Moderator
WheatPuppet
Member
Member # 5142

 - posted      Profile for WheatPuppet   Email WheatPuppet         Edit/Delete Post 
Actually PostgreSQL is my favorite databsae out there. I had to work with Microsoft's attempt at SQL over the summer with Microsoft Access, and that was about as fun as poking myself with a hobby knife.

I'll look into BDB and see if it's supported.

Also, the server does have MySQL installed, but it's use is reserved for more important people than me.

Posts: 903 | Registered: May 2003  |  IP: Logged | Report this post to a Moderator
MrSquicky
Member
Member # 1802

 - posted      Profile for MrSquicky   Email MrSquicky         Edit/Delete Post 
Wheat,
If that doesn't work, you can use CSV files like a database. There should be plenty of resources out there to do this in PHP.

Posts: 10177 | Registered: Apr 2001  |  IP: Logged | Report this post to a Moderator
   

   Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:


Contact Us | Hatrack River Home Page

Copyright © 2008 Hatrack River Enterprises Inc. All rights reserved.
Reproduction in whole or in part without permission is prohibited.


Powered by Infopop Corporation
UBB.classic™ 6.7.2