Results 1 to 10 of 10

Thread: Which DBMS?

  1. Dec 7th, 2005, 08:52 AM #1
    tr333
    tr333 is offline

    Thread Starter
    Frenzied Member tr333's Avatar
    Join Date
    Nov 2004
    Location
    /dev/st0
    Posts
    1,605

    Which DBMS?

    What would be the best database system for a small .NET application?
    i have been reading some info on MySQL and PostgreSQL, but can't really see what is different between them.

    Any other suggestions? I can't use MS-Access/SQL-Server because this appication has to run on OSX/Linux.

    EDIT: i am also low on $$$ so i dont want to pay for anything.
    Last edited by tr333; Dec 7th, 2005 at 08:59 AM.
    CSS layout comes in to the 21st century with flexbox!
    Just another Perl hacker,
    Reply With Quote Reply With Quote
  2. Dec 7th, 2005, 09:22 AM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Which DBMS?

    What about XML files?
    Reply With Quote Reply With Quote
  3. Dec 7th, 2005, 06:34 PM #3
    tr333
    tr333 is offline

    Thread Starter
    Frenzied Member tr333's Avatar
    Join Date
    Nov 2004
    Location
    /dev/st0
    Posts
    1,605

    Re: Which DBMS?

    you cant run SQL queries on XML files.
    CSS layout comes in to the 21st century with flexbox!
    Just another Perl hacker,
    Reply With Quote Reply With Quote
  4. Dec 7th, 2005, 06:43 PM #4
    kaihirst
    kaihirst is offline
    Fanatic Member kaihirst's Avatar
    Join Date
    Jul 2005
    Location
    The Resaurant At the End of The Universe
    Posts
    633

    Re: Which DBMS?

    mySQL is made for the friendly penguin..

    postgreSQL is made for the unfriendly unix and can run on mr antarctica, but not too well

    If your running the wingless bird, mySQL... much easier to deal with and its like feeding him fish...

    Kai
    As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..

    A few things that make a good Developer a Great One.
    Methodical and a thorough approach to research and design inevitably leads to success.
    Forward thinking is the key to Flow of control.
    Never test in the design environment, always test in real time, you get the REAL results.
    CBSE & OOSE are the same animal, they just require different techniques, and thinking.
    SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
    The key to good design is explicit attention to both detail and response.
    Think Freely out of the "Box" you're in..... You will soar to better heights.

    Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT

    Reply With Quote Reply With Quote
  6. Dec 8th, 2005, 09:42 AM #5
    tr333
    tr333 is offline

    Thread Starter
    Frenzied Member tr333's Avatar
    Join Date
    Nov 2004
    Location
    /dev/st0
    Posts
    1,605

    Re: Which DBMS?

    anyone ever tried firebird?
    CSS layout comes in to the 21st century with flexbox!
    Just another Perl hacker,
    Reply With Quote Reply With Quote
  7. Dec 8th, 2005, 10:31 AM #6
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Which DBMS?

    You did mention a small .NET application. If it's using negligibly small data, you can simply use XML files. That's what I was saying. Although if you write a wrapper class, you can use SQL queries on XML files
    Reply With Quote Reply With Quote
  8. Dec 8th, 2005, 11:19 AM #7
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Which DBMS?

    Especialy if you load it into a Dataset..... then you can do all sorts of things with it.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  9. Dec 8th, 2005, 01:34 PM #8
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Re: Which DBMS?

    Quote Originally Posted by tr333
    anyone ever tried firebird?
    I installed it once without any issues. Then I could not figure out what was happening. So I uninstalled it. Haven't tried it again.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  11. Dec 8th, 2005, 01:36 PM #9
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228

    Lightbulb Re: Which DBMS?

    Quote Originally Posted by tr333
    What would be the best database system for a small .NET application?
    i have been reading some info on MySQL and PostgreSQL, but can't really see what is different between them.

    Any other suggestions? I can't use MS-Access/SQL-Server because this appication has to run on OSX/Linux.

    EDIT: i am also low on $$$ so i dont want to pay for anything.
    Just wondering if you could work on plain csv files. Its possible to populate ADO Datasets as well.
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
  12. Dec 12th, 2005, 12:41 AM #10
    tr333
    tr333 is offline

    Thread Starter
    Frenzied Member tr333's Avatar
    Join Date
    Nov 2004
    Location
    /dev/st0
    Posts
    1,605

    Re: Which DBMS?

    Quote Originally Posted by mendhak
    You did mention a small .NET application. If it's using negligibly small data, you can simply use XML files. That's what I was saying. Although if you write a wrapper class, you can use SQL queries on XML files
    EDIT: would i just use DataSet/DataTable/DataView objects to do this? i haven't really used ADO.NET much before.
    Last edited by tr333; Dec 12th, 2005 at 12:49 AM.
    CSS layout comes in to the 21st century with flexbox!
    Just another Perl hacker,
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width