Standalone DB (like Access) for PHP/Apache

[commanderblop@hotmail.com]

Hi there,
I am in the process of translating an WIndows/ASP/MsSQL Content
Managment System (CMS) to Linux/PHP/???.

Is there a popular database I can use that will allow standalone files
like Access did (which used .MDB files)?

In order for the CMS to work, there needs to be a standalone database
file that is self-contained, just like Access .mdb files are under
Windows. I guess I am asking for an Access equivalent for
Linux/Apache.

Any help is appreciated!

Holden

[Michael Vilain]

Re: Standalone DB (like Access) for PHP/Apache

In article <1106522893.639 259.287700@z14g 2000cwz.googleg roups.com>,
commanderblop@h otmail.com wrote:
[color=blue]
> I am in the process of translating an WIndows/ASP/MsSQL Content
> Managment System (CMS) to Linux/PHP/???.
>
> Is there a popular database I can use that will allow standalone files
> like Access did (which used .MDB files)?
>
> In order for the CMS to work, there needs to be a standalone database
> file that is self-contained, just like Access .mdb files are under
> Windows. I guess I am asking for an Access equivalent for
> Linux/Apache.[/color]


I'm not aware of anything like this on Linux, unfortunately. If there
is such a beast, it's 3rd-party proprietary. The monst method of Linux
PHP database integration is MySQL or Postgres. Neither of these fit
your requirements.

I think you'll have to revisit them. Good luck.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

[lunatech]

Re: Standalone DB (like Access) for PHP/Apache

commanderblop@h otmail.com wrote:[color=blue]
> Hi there,
> I am in the process of translating an WIndows/ASP/MsSQL Content
> Managment System (CMS) to Linux/PHP/???.
>
> Is there a popular database I can use that will allow standalone[/color]
files[color=blue]
> like Access did (which used .MDB files)?[/color]

Sqllite (http://www.php.net/sqlite) is probably what you need .

--

Raj Shekhar
System Administrator, programmer and slacker
home : http://rajshekhar.net
blog : http://rajshekhar.net/blog/

[Ramius]

Re: Standalone DB (like Access) for PHP/Apache

If you don't require SQL statements, you could also have a look at:

http://www.php.net/dba

[NC]

Re: Standalone DB (like Access) for PHP/Apache

commanderblop@h otmail.com wrote:[color=blue]
>
> I am in the process of translating an WIndows/ASP/MsSQL Content
> Managment System (CMS) to Linux/PHP/???.
>
> Is there a popular database I can use that will allow standalone
> files like Access did (which used .MDB files)?[/color]

Yes and no. Access and other desktop-oriented database systems
have standalone files which include data, indices, and interface
objects (forms, queries, reports, etc.) Assuming you only need
to store data and indices, you should try SQLite:

http://www.php.net/sqlite

http://sqlite.org/

Cheers,
NC