Is there such a thing as...

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
SpiderMonkey
Forum Commoner
Posts: 85
Joined: Fri May 05, 2006 4:48 am

Is there such a thing as...

Post by SpiderMonkey »

...an sql database simulator that just spews out filler information, so you can test php database code quickly without having to mess about creating a database?
kamme
Forum Newbie
Posts: 4
Joined: Thu Jun 01, 2006 4:01 am

Post by kamme »

Well, if you are using basic query's, try sqlite.

http://be.php.net/sqlite

The problem is that sqlite doesn't support everything mysql does, but it's easy to use because the whole database is in one file...
Syranide
Forum Contributor
Posts: 281
Joined: Fri May 20, 2005 3:16 pm
Location: Sweden

Post by Syranide »

hehe, how do you intend do test a database application with the SQL-queries just returning random garbage? doesn't sound very useful to me really, unless you mean something that fills the database with random garbage, but that doesn't sounds very useful either.

but, I generally just set up some for loops that calls my methods for doing stuff with the database filling it with random "correct" garbage.
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

I agree about testing 'random garbage'; however there are ways to populate databases with test data that have some resemblance to real data.

this php class (http://www.phpclasses.org/browse/file/7890.html) can be used to generate names, addresses, dates, numbers (to use as prices, etc) and telephone numbers to populate a database.

There are ways to 'scrape' sites that contain lists of various data so that you can build an archive of numerous test data.

Lite...
Post Reply