Results 1 to 8 of 8

Thread: Need help choosing the database !!!

  1. #1
    Join Date
    May 2011
    Beans
    143
    Distro
    Ubuntu 12.04 Precise Pangolin

    Need help choosing the database !!!

    I am developing an application for billing system(in c sharp), i need to have a small database to store the bills and retrieve as and when required. I don wish to go in for any mysql, postgresql kinda dbs where i need to have a client server model ... what other databases u think can i use for this BILLING APPLICATION IN C# .NET

  2. #2
    Join Date
    May 2010
    Location
    SE England
    Beans
    210

    Re: Need help choosing the database !!!

    Assuming your data requirements are reasonably modest (sub TB), then I'd recommend you take a look at Sqlite; Its serverless small and reasonably fast.


    Bouncingwilf
    Last edited by bouncingwilf; September 27th, 2012 at 06:08 PM. Reason: Typo

  3. #3
    Join Date
    Aug 2011
    Location
    47°9′S 126°43W
    Beans
    1,915
    Distro
    Kubuntu 12.10 Quantal Quetzal

    Re: Need help choosing the database !!!

    Quote Originally Posted by vikkyhacks View Post
    I am developing an application for billing system(in c sharp), i need to have a small database to store the bills and retrieve as and when required. I don wish to go in for any mysql, postgresql kinda dbs where i need to have a client server model ... what other databases u think can i use for this BILLING APPLICATION IN C# .NET
    The big advantage of the canonical server-based DB is that it is easy to have several concurrent uses. And if your application has any future this requirement will show up. This also allows someday to move the DB server to another machine to spread the load, etc...

  4. #4
    Join Date
    May 2011
    Beans
    143
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Need help choosing the database !!!

    i dont need a server/client for model for this simple software which will run in any old p4 with 256gigs of ram and one billing clerk sitting on it, i need any file based system, Is there any other file based system other than SQLite ????

  5. #5
    Join Date
    Jul 2012
    Beans
    57

    Re: Need help choosing the database !!!

    Quote Originally Posted by vikkyhacks View Post
    i dont need a server/client for model for this simple software which will run in any old p4 with 256gigs of ram and one billing clerk sitting on it, i need any file based system, Is there any other file based system other than SQLite ????
    There is berkeley db, but I don't really know how its architecture has changed over the years. It used to not support SQL statements, but the wiki page says that Oracle corp. now owns the software and added sqlite to it. Maybe they just added the query parser?
    Last edited by mevun; September 29th, 2012 at 04:19 PM. Reason: grammar

  6. #6
    Join Date
    Sep 2005
    Location
    Rural Nevada, USA
    Beans
    297
    Distro
    Ubuntu 14.04 Trusty Tahr

    Re: Need help choosing the database !!!

    What's wrong with sqlite?

  7. #7
    Join Date
    May 2011
    Beans
    143
    Distro
    Ubuntu 12.04 Precise Pangolin

    Re: Need help choosing the database !!!

    Quote Originally Posted by llanitedave View Post
    What's wrong with sqlite?
    i am looking for something strongly typed, i don want the datatype to change depending on the inputs that i feed it, like how sqlite has, i need triggers, stored procedures and all the features (at least 60% of what SQL Server, MySQL, Oracle give )

    I just can't digest the fact that only ms access(i hate it and which is M$)and SQLite are the only file based database systems that i can find ...

  8. #8
    Join Date
    Sep 2006
    Beans
    145

    Re: Need help choosing the database !!!

    Quote Originally Posted by vikkyhacks View Post
    I just can't digest the fact that only ms access(i hate it and which is M$)and SQLite are the only file based database systems that i can find ...
    The more important question really is do you require ACID compliant databases? If not, there are all kinds of options, including NoSQL.

    Unfortunately, if you are running a flatfile/embedded database on the Windows platform (assuming Windows because of C#), and thus not using a client/server database - the only two reasonable opensource choices are probably SQLite or Berkeley. In order to save yourself time and sanity - and have all the features of stored procedures - I'd resign myself to using a local copy of either SQL Server Express, MySQL, or PostgreSQL.
    Last edited by T.J.; September 30th, 2012 at 09:17 AM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •