Re: What is the Right Database For Me??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Gabe,
Thank you for your insights. They are very helpful.

So far I am using Access primarily out of habit. As soon as I get the
rush job out, I think I will look at using Firebird. I have built a
Data Access Layer that should work with it.

One last question, if I may...how is the performance compared to
something like Access? By that I mean speed of selecting and updating
records.

Thanks again,
John

On Wed, 18 May 2005 05:35:32 -0700, "gabe"
<gabe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>jl, i've started a project with firebird and am mostly happy with what it
>offers so so and i can answer a few of these,
>
>> 1. Currently my apps create thier database from scratch
>> programmatically using DAO and Jet. When you distribute an app using
>> Firebird (or any other SQL server) do you include a shell database?
>
>no, my app creates the db (i think it takes maybe 4 lines of code) and then
>generates the required tables as needed thru their .net provider using
>standard ddl
>
>> 2. How do you handle modifications/updates to the structure once it is
>> installed?
>
>ddl
>
>
>> 3. How do you determine where to install it?
>
>i have a default location, but it is configurable from within the app
>
>
>> 4. Do your customers have to learn to be DBA's to support Firebird?
>
>using the embedded engine there isnt really config/support so far (aside
>from a few parameters in the inital db creation, but the project hasent
>reached full production yet. so far the customers dont know that there is
>even another db to support. we'll see when it starts to load up further.

.

Relevant Pages

  • Re: What is the Right Database For Me??
    ... When you distribute an app using ... > Firebird do you include a shell database? ... Do your customers have to learn to be DBA's to support Firebird? ... so far the customers dont know that there is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Triggers in Firebird and C63EE
    ... i made an example app that use some firebird tables, ... handle autoinc sql triggers. ... How to handle these triggers? ... Use combination of App triggers and procedures which return ID. ...
    (comp.lang.clarion)
  • Re: Need a database that handles the following...
    ... > Your best bet is Firebird, it can do everything you want and it has a dll ... > you can also embed the whole thing in your app. ... Bradley ...
    (borland.public.delphi.non-technical)
  • Informix 4gl to Delphi Win32?
    ... 4gl app to Delphi? ... I can do the Firebird conversion but would ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Suggestoins for Local DB to use with Shareware
    ... "Fikret Hasovic" skrev ... Latest version is on first link;-) ... Firebird + App on a USB stick ...
    (borland.public.delphi.non-technical)