small database needed
-
Hallo, I need a small sql database. The database should be able to handle inner joins and return something like a recordset or an array of values. It is not necessary for the database to support things like group by, count, max, min and other more complicated sql select statements. The database has to support unicode string types. No other types are required. Yes, a method to add a new record should be avaiable. No need for updating a record. I could create create a new record and delete the old one instead. It's not necessary that this has to be done with SQL. Any kind of method can do. Oh, yes it should support "delete from table where ..." Sequences, stored procedures are not required. Support for Indexes should be avaiable. Some functions to create a table or index is required. Not necessary to be SQL. A drop table function is also required. Basically I need a database which has the functionality of microsoft adoce and cedb (Ce object store). I need to replace adoce and cedb and the Odyssey Software wrapper. no support for sync is required. No support for .net,ado.net or cdb is required either. It's fine if I can use it with C++ (embedded Visual C) The database should be written in C++ or C and should compile with evc 3 or 4. Primarilly it must work with strongarm processors. The database must be small in size and memory consumption. It must run on a machine which has just a view megabyte of RAM avaiable. The database will be used to collect medical records of hilltribe people in remote areas of Laos, Burma, Thailand and Vietnam. It's for a NGO, so it should not cost any serious money and should be open source, so I can remove not required functionality. Unicode support is a must. The database will be only used on the device. No RAD or sync. technology is required. Primarily we use HP Pocket PC hardware. Support for PC is not required. It must have a much smaller footprint than sql server ce has. Anybody a sugjestion. Thanks a lot. Chris :) Vietiane Lao (PDR) Bangkok, Thailand
-
Hallo, I need a small sql database. The database should be able to handle inner joins and return something like a recordset or an array of values. It is not necessary for the database to support things like group by, count, max, min and other more complicated sql select statements. The database has to support unicode string types. No other types are required. Yes, a method to add a new record should be avaiable. No need for updating a record. I could create create a new record and delete the old one instead. It's not necessary that this has to be done with SQL. Any kind of method can do. Oh, yes it should support "delete from table where ..." Sequences, stored procedures are not required. Support for Indexes should be avaiable. Some functions to create a table or index is required. Not necessary to be SQL. A drop table function is also required. Basically I need a database which has the functionality of microsoft adoce and cedb (Ce object store). I need to replace adoce and cedb and the Odyssey Software wrapper. no support for sync is required. No support for .net,ado.net or cdb is required either. It's fine if I can use it with C++ (embedded Visual C) The database should be written in C++ or C and should compile with evc 3 or 4. Primarilly it must work with strongarm processors. The database must be small in size and memory consumption. It must run on a machine which has just a view megabyte of RAM avaiable. The database will be used to collect medical records of hilltribe people in remote areas of Laos, Burma, Thailand and Vietnam. It's for a NGO, so it should not cost any serious money and should be open source, so I can remove not required functionality. Unicode support is a must. The database will be only used on the device. No RAD or sync. technology is required. Primarily we use HP Pocket PC hardware. Support for PC is not required. It must have a much smaller footprint than sql server ce has. Anybody a sugjestion. Thanks a lot. Chris :) Vietiane Lao (PDR) Bangkok, Thailand
-
Hallo, I need a small sql database. The database should be able to handle inner joins and return something like a recordset or an array of values. It is not necessary for the database to support things like group by, count, max, min and other more complicated sql select statements. The database has to support unicode string types. No other types are required. Yes, a method to add a new record should be avaiable. No need for updating a record. I could create create a new record and delete the old one instead. It's not necessary that this has to be done with SQL. Any kind of method can do. Oh, yes it should support "delete from table where ..." Sequences, stored procedures are not required. Support for Indexes should be avaiable. Some functions to create a table or index is required. Not necessary to be SQL. A drop table function is also required. Basically I need a database which has the functionality of microsoft adoce and cedb (Ce object store). I need to replace adoce and cedb and the Odyssey Software wrapper. no support for sync is required. No support for .net,ado.net or cdb is required either. It's fine if I can use it with C++ (embedded Visual C) The database should be written in C++ or C and should compile with evc 3 or 4. Primarilly it must work with strongarm processors. The database must be small in size and memory consumption. It must run on a machine which has just a view megabyte of RAM avaiable. The database will be used to collect medical records of hilltribe people in remote areas of Laos, Burma, Thailand and Vietnam. It's for a NGO, so it should not cost any serious money and should be open source, so I can remove not required functionality. Unicode support is a must. The database will be only used on the device. No RAD or sync. technology is required. Primarily we use HP Pocket PC hardware. Support for PC is not required. It must have a much smaller footprint than sql server ce has. Anybody a sugjestion. Thanks a lot. Chris :) Vietiane Lao (PDR) Bangkok, Thailand
-
Hallo, I need a small sql database. The database should be able to handle inner joins and return something like a recordset or an array of values. It is not necessary for the database to support things like group by, count, max, min and other more complicated sql select statements. The database has to support unicode string types. No other types are required. Yes, a method to add a new record should be avaiable. No need for updating a record. I could create create a new record and delete the old one instead. It's not necessary that this has to be done with SQL. Any kind of method can do. Oh, yes it should support "delete from table where ..." Sequences, stored procedures are not required. Support for Indexes should be avaiable. Some functions to create a table or index is required. Not necessary to be SQL. A drop table function is also required. Basically I need a database which has the functionality of microsoft adoce and cedb (Ce object store). I need to replace adoce and cedb and the Odyssey Software wrapper. no support for sync is required. No support for .net,ado.net or cdb is required either. It's fine if I can use it with C++ (embedded Visual C) The database should be written in C++ or C and should compile with evc 3 or 4. Primarilly it must work with strongarm processors. The database must be small in size and memory consumption. It must run on a machine which has just a view megabyte of RAM avaiable. The database will be used to collect medical records of hilltribe people in remote areas of Laos, Burma, Thailand and Vietnam. It's for a NGO, so it should not cost any serious money and should be open source, so I can remove not required functionality. Unicode support is a must. The database will be only used on the device. No RAD or sync. technology is required. Primarily we use HP Pocket PC hardware. Support for PC is not required. It must have a much smaller footprint than sql server ce has. Anybody a sugjestion. Thanks a lot. Chris :) Vietiane Lao (PDR) Bangkok, Thailand
Check out http://hsql.sourceforge.net/[^] It is an embeddable database engine also. Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/
http://deepakvasudevan.blogspot.com/
http://deepak.blogdrive.com/ -
PJ Arends wrote:
Does Sqlite[^] work for you?
Glad you suggested it as it was the first thing that I thought of while reading the OP; and it looks like you got voted down for doing so. Who knows why, that is unless you have been poking the trolls again (yes I realize I’m a troll but I dont vote people down).
-
Hallo, I need a small sql database. The database should be able to handle inner joins and return something like a recordset or an array of values. It is not necessary for the database to support things like group by, count, max, min and other more complicated sql select statements. The database has to support unicode string types. No other types are required. Yes, a method to add a new record should be avaiable. No need for updating a record. I could create create a new record and delete the old one instead. It's not necessary that this has to be done with SQL. Any kind of method can do. Oh, yes it should support "delete from table where ..." Sequences, stored procedures are not required. Support for Indexes should be avaiable. Some functions to create a table or index is required. Not necessary to be SQL. A drop table function is also required. Basically I need a database which has the functionality of microsoft adoce and cedb (Ce object store). I need to replace adoce and cedb and the Odyssey Software wrapper. no support for sync is required. No support for .net,ado.net or cdb is required either. It's fine if I can use it with C++ (embedded Visual C) The database should be written in C++ or C and should compile with evc 3 or 4. Primarilly it must work with strongarm processors. The database must be small in size and memory consumption. It must run on a machine which has just a view megabyte of RAM avaiable. The database will be used to collect medical records of hilltribe people in remote areas of Laos, Burma, Thailand and Vietnam. It's for a NGO, so it should not cost any serious money and should be open source, so I can remove not required functionality. Unicode support is a must. The database will be only used on the device. No RAD or sync. technology is required. Primarily we use HP Pocket PC hardware. Support for PC is not required. It must have a much smaller footprint than sql server ce has. Anybody a sugjestion. Thanks a lot. Chris :) Vietiane Lao (PDR) Bangkok, Thailand
-
