database-engine

How to write a simple database engine

I am interested in learning how a database engine works (i.e. the internals of it). I know most of the basic data structures taught in CS (trees, hash tables, lists, etc.) as well as a pretty good understanding of compiler theory (and have implemented a very simple interpreter) but I don't understand how to go about writing a database e...

How to force table select to go over blocks

How can I make Sybase's database engine return an unsorted list of records in non-numeric order? ~~~ I have an issue where I need to reproduce an error in the application where I select from a table where the ID is generated in sequence, but the ID is not the last one in the selection. Let me explain. ID STATUS _____________ 1234 ...

Database Engine not appearing in SQL Server listing

I don't know if I'm searching for the wrong queries in google but I can't seem to find an answer to this. I have SQL Server 2008 installed in my pc and according to services.msc, I've got 2 database engines running: SQLEXPRESS (probably one that came along with Visual Studio) and MSSQLSERVER. When I try to connect only SQLEXPRESS is visi...

What is the difference between SQL Server Compact Edition and SQL Server Express Edition?

Hi, Can someone please explain what is the main difference between SQL Server Compact Edition and SQL Server Express Edition? For what purpose I should use this or that one? Thanks ...

Database and DB engine for social website

For a heavy user content website with user profiles, live feeds, photo /video/content sharing, etc what DB to use, and what DB engine? Ofcourse Oracle/Microsoft sql are out because they are not free (or cheap). I am using MySQL with MyISAM but that will run into performance issues on a social site. Even using InnoDB may not help performa...