Quantcast

A community for students. Sign up today!

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

agdgdgdgwngo

  • 2 years ago

When would one use a database engine over a text file/XML file to store application data? Also, what is the difference between the three free SQL engines like PostgreSQL, MySQL, and SQLite, and why is MySQL the most popular of them all?

  • This Question is Closed
  1. calmchessplayer
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    When large BLOB files are being stored or data that is changing daily or needs to be cross refrenced what not thats some basic uses of a search engine statistical data queries is another so many need big book to cover it all.

  2. KonradZuse
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    It depends what you are doing... Not too sure the differences in SQL programs, but everyone has their favorite. If you are doing a client only program you could use Access as well.

  3. rsmith6559
    • 2 years ago
    Best Response
    You've already chosen the best response.
    Medals 1

    XML has a lot of overhead. It's good for transmitting data, because it marks it up with the data's context. For output, it needs to be parsed. Flat file, file system, RDBMS, any way you go you're going to have to input the data, and what do you want to do when you output the data? How much data? How structured? RDBMSs are written to store fairly structured data. They're optimized for searching through huge numbers of rows of data. Using regular expressions, a large flat file can be easily and quickly searched. The file system can be leveraged for some searching, but file systems can limit how many files in a directory. SQLite isn't designed to be used on big amounts of data. That said, one of the softwares at work uses SQLite, and the database file is 300MB. PostgreSQL and MySQL are both excellent RDBMSs IMO.

  4. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Ask a Question
Find more explanations on OpenStudy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.