Re: How do sqlservers work!

http://sourceforge.net/projects/hsqldb/

is listed as a small (100k) database written in java.

It might be a good place to look.

Unfortunately, smaller databases tend to lack a lot of the functionality
of their larger, more complex cousins.

Dates are stored in many different ways. For instance, in postgresql you
can store them in two different ways based on how you configured the
database. (Or is that timestamps, I think it's timestamps that can be
stored as 64 bit ints...)

On Thu, 27 Feb 2003, wmac wrote:

> Hello,
>
> I had posted this in "novice" group but as I did not get any reply I am
> posting again here.
>
> I am working on a small article (educational article as a part of my
> course) about SQL servers and I have some general questions and I'll
> appereciate if someone can answer. (just small replies so that I can
> find my way and look for more info).
>
> 1- How do SQL servers put datas in files? I am a C Programmer and I have
> developped programs for MySQL/MSSQL/Oravle/PostgreSQL.
>
> 2- Is there a verys small SQL server that I can take a look at some
> parts of the code and I can have a view of their structure?
>
> 3- Can you give me some advice on how can I gather enough information to
> be able to develop a very very small SQL server with just 4 commands
> (doing simple SELECT, INSERT, CREATE DATABASE and CREATE TABLE with
> simple options).
>
> I want to work on this for my M.Sc project.
>
> Regards,
> Mac
> --
> Indy Programming Forums: http://onlineprogrammer.org/forums
> http://OnlineProgrammer.org: Articles, Resources, Forums
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>