School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Programming Help

Web Development



What's Here?

  • Members: 309,245
  • Replies: 846,840
  • Topics: 141,708
  • Snippets: 4,502
  • Tutorials: 1,166
  • Total Online: 2,649
  • Members: 148
  • Guests: 2,501

Welcome to Dream.In.Code
Become an Expert!

Join 309,245 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,649 people online right now. Registration is fast and FREE... Join Now!




SQL interpreter to create mock database

 

SQL interpreter to create mock database, for practicing purpose
ethereal1m

21 Aug, 2009 - 05:56 PM
Post #1

D.I.C Head
Group Icon

Joined: 29 Jun, 2009
Posts: 105



Thanked: 1 times
Dream Kudos: 50
My Contributions
Hi Coders,
as a newbie in a database world, I would like to know if a standalone SQL interpreter software to create a mock database exists? By a mock database means that it shows the schema and its details but cannot be used or filled with values, but it can be modified, queried, and deleted.

Best regards,
ethereal1m

This post has been edited by ethereal1m: 21 Aug, 2009 - 06:02 PM

User is offlineProfile CardPM
+Quote Post


Martyr2

RE: SQL Interpreter To Create Mock Database

22 Aug, 2009 - 08:46 AM
Post #2

Programming Theoretician
Group Icon

Joined: 18 Apr, 2007
Posts: 7,335



Thanked: 845 times
Expert In: C/C++, Java, VB, VB.NET, C#, PHP, Web Development, HTML & CSS, Javascript

My Contributions
I can't say for sure if this exists or not, but there seems to be problems in how you decribe it. For instance, if you can't fill it with values, what would be queried then? If you just mean create an empty database with a schema and stuff, sure. You can do this on any database with an SQL script and even standalone modeling software could build these databases.

I guess you will have to describe the situation a little better to know what exactly you are looking to do. smile.gif
User is offlineProfile CardPM
+Quote Post

ethereal1m

RE: SQL Interpreter To Create Mock Database

22 Aug, 2009 - 07:00 PM
Post #3

D.I.C Head
Group Icon

Joined: 29 Jun, 2009
Posts: 105



Thanked: 1 times
Dream Kudos: 50
My Contributions
Hi Martyr2,
Good point! I was contradicting myself with my question. I'm practicing sql in oracle sql developer and oracle XE environment. It's good except my laptop has a scarce resource thus running oracle database is little bit slow on it. So, I'm looking an alternative small scale, stripped down SQL interpreter that makes my practicing simpler and easier. Any suggestion?
User is offlineProfile CardPM
+Quote Post

Nallo

RE: SQL Interpreter To Create Mock Database

28 Aug, 2009 - 01:32 PM
Post #4

New D.I.C Head
*

Joined: 19 Jul, 2009
Posts: 24



Thanked: 3 times
My Contributions
Hello ethereal1m,

You may want to look at SQLite for a lightweight SQL-Interpreter.

Unlike Mysql or Oracle it is "serverless". This has big disadvantages with lots of connections, but might be fine for your "just fooling around on my laptop" enviroment, where you are the only customer.

disclaimer: bear in mind, that if you learn your Oracle with an other SQL-Interpreter ... SQL dialects slightly differ ...
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/26/09 09:36AM
Invision Power Board v2.1.7 © 2009  IPS, Inc.
Licensed to: MediaGroup1

Live Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month