[Max]

We're looking for a sample database table or two to help populate the SQL Sandbox, basically so people will have something to work with when they go there.

There are already a few tables in the sandbox db:

CSS Colors,
A list of  companies
Some fictitious company departments
Some fictitious employees

The last three can be used to try out joins and stuff, but it would be nice to have some other sample tables in there. Anyone have some sources of sample data?

I looked at some geoip tables but they seem a little too big (20 or 30 megs).

[bizzar]

I'm uploading a bunch of databases I got a few years back that are pretty common with the people who sell these things... I think I paid like $5 for the lot of them.

Here's the link...
http://www.bizzartech.com/demo/DBs/

I'm still uploading, but they should be all there in about 30 minutes. Hope this helps.

[Max]

Thank you, Bizzar, I'll wait a bit and go have a look at them.

EDIT:

Wow, lotta stuff.

The "airports" one might be useful for people to run queries against. Are there any you'd suggest as being good for people to learn on or play with?

I'm uploading a bunch of databases I got a few years back that are pretty common with the people who sell these things... I think I paid like $5 for the lot of them.

Here's the link...
http://www.bizzartech.com/demo/DBs/

I'm still uploading, but they should be all there in about 30 minutes. Hope this helps.

[bizzar]

I haven't really gone through them... it was one of those, I'll buy em now and deal with them later if I need them. But your welcome to any of them.... so is anyone. I'll leave em up for a few days so people can grab them if they want. Makes for fun/interesting practice if people are willing to download mysql or oracle xe if they are bored.

[Max]

Makes for fun/interesting practice if people are willing to download mysql or oracle xe if they are bored.

I'd consider putting oracle xe on the server here and creating a sandbox for it, but I'm not sure exactly what the licensing terms allow.

They state that it's "free to develop, deploy, and distribute", but I don't know if that covers its use here. They also mention that it's intended for "Educational institutions and students who need a free database for their curriculum", but again I don't know if that includes our using it here. (??)

[bizzar]

The uploads are done.

The oracle xe licenses are pretty open, but does come with a couple restrictions. I think a 4gb max db size overall and some other minor restrictions. But my favorite saying that came from the developers I work with is, "It's easier to ask for forgiveness than it is for permission".

 

[Max]

But my favorite saying that came from the developers I work with is, "It's easier to ask for forgiveness than it is for permission".

Yep, that's been the Guiding Principle for my marriage, lol.

As for the "scriptsdb.zip" file there...hmmm, did someone naughty snag a copy of the database from a certain well-known scripts site?    goodness gracious, lol.

[bizzar]

probably. I have a ton of nonsense downloaded and saved off to dvd. some things linger on the server at home and I remembered them. I can take it down if it's inappropriate. don't know the grounds rules for random files.

[Max]

No, no need to take it down. I also have tons of odd stuff saved here and there. It's easier to archive it in case I need it someday. If I delete it then it's guaranteed that I'll need it a week later.