473,322 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

The convenient database engine for a "Distributed" System

Hi all...
Here is my infrastructure design of a "distributed" system:
- Many (30-50) hosts connected via VPN to a server.
- Each host manages a system that receives local data (stored in a
local database), and has to be sent to the server, so the rest of the
hosts can "see" this data.

What I want? I want to have a
portable/changeable/easy-installation/cross-platform local database.

The problem is that the database structure may change, so I have to
change the database structure of each host. As you can see, it requires
the database structure to be very portable and changeable.

I think there is 2 database paradigms to consider: The Access-like one,
and the MySQL-like one. With the Access-like paradigm, it only needs
the file .mdb on the local host, and its respectively set of dlls to
manipulate it. But, I remember that I need a cross platform database...
On the other hand, the MySQL-like paradigm, needs the database engine
to be installed for running. The cons of it, is that is more difficult
(I don't know yet if a can do it) to install it silently, I mean
without user intervention, whereas a .mdb file being a member of the
system installation files is totally viable.

I heard about sqlite... Any comments?

Jul 18 '05 #1
3 1863


I've not used it personnally, but I heard good things about it :

"Firebird is a relational database offering many ANSI SQL-99 features that
runs on Linux, Windows, and a variety of Unix platforms. Firebird offers
excellent concurrency, high performance, and powerful language support for
stored procedures and triggers. It has been used in production systems,
under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers,
technical advisors and supporters developing and enhancing a
multi-platform relational database management system based on the source
code released by Inprise Corp (now known as Borland Software Corp) on 25
July, 2000 under the InterBase Public License v.1.0.

Firebird is completely free of any registration, licensing or deployment
fees. It may be deployed freely for use with any third-party software,
whether commercial or not.."

These seems to be an embedded version so that you can embed the library
in your app and make everything nice and monolithic.
Jul 18 '05 #2
I also recommend Firebird. I like the fact that the database is in its
own file that can be copied from one platform to another. I use it on
Linux, but it works just as well on Windows.

Grig

Jul 18 '05 #3
Grig Gheorghiu wrote:
I also recommend Firebird. I like the fact that the database is in its
own file that can be copied from one platform to another.


Although you can only do that between platforms having
the same byte order. Backing up and restoring is a more
reliable way to do cross-platform database copying.

--
Greg Ewing, Computer Science Dept,
University of Canterbury,
Christchurch, New Zealand
http://www.cosc.canterbury.ac.nz/~greg
Jul 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Sarah Tanembaum | last post by:
I was wondering if it is possible to create a secure database system using RDBMS(MySQL, Oracle, SQL*Server, PostgreSQL etc) and web scripting/programming language(Perl, PHP, Ruby, Java, ASP, etc)...
36
by: Andrea Griffini | last post by:
I did it. I proposed python as the main language for our next CAD/CAM software because I think that it has all the potential needed for it. I'm not sure yet if the decision will get through, but...
7
by: J Goldman | last post by:
I'm looking for documentation pointers to learn what I need to put together a distributed database system. I've read through "Oracle 9i Database Administrator's Guide: Distributed Database...
0
by: Sean Powell | last post by:
I am a SQL Server DBA Manager and my employer (Symantec) will be opening a position in the near future (20-60 days) for my DBA team. Here is the job description:...
6
by: hercules | last post by:
Hi: In some code , I used typedef unsigned char BOOL; /*boolean */ But in other code , I must use typedef unsigned int BOOL; /* boolean */ How to remove the previous typedef ? ...
9
by: Mike Labosh | last post by:
Code is easy. These are two OOP design issues that I am chewing on. Coming from classic VB, I'm not great at OO design. I prefer to write mile long spaghetti methods in a Temp module, and then...
1
by: David Elliott | last post by:
I have a distributed system that processes documents. There currently is an Async Webservice in place and this works fine. My customer is requesting a Sync Webservice call. I am trying to...
4
by: dgleeson3 | last post by:
Hello all I am creating a VB.Net distributed SQL server 2005 application. Each computer in the system has a database with a table of users and their telephone numbers. Each computer has a...
4
by: raidvvan | last post by:
Hi there, We have been looking for some time now for a database system that can fit a large distributed computing project, but we haven't been able to find one. I was hoping that someone can...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.