Multi Platform Database
-
Hi, I am considering using Mono to develop an specific purpose image browser to run on Windows, MAC/OS and Linux. To meet performance requirements the application requires a database to store thumbnails and search data. I am looking for suggestions for database products that run on Windows, MAC/OS and Linux that do not require use of technologies such as VMWare or Parallels, which I could use from within a Mono/C# environment. The application along with the database and the images will be distributed at no cost to "qualified" users, so I'm looking for a zero cost run time database system. The application must run stand-alone - i.e. no network, no servers, The thumbnails and search data would be imported from the original image files. The search data would be sourced from embedded IPTC metadata such as keywords and supplemental categories. The thumbnail and IPTC metadata are injected into the image files using a commercial Digital Asset Management (DAM) application. I don't insist that the "database" be SQL compliant, b-tree indexes would probably suffice. As long as the same database or index files can be used from within the same Mono application running on Windows, MAC/OS or Linux. TIA
-
Hi, I am considering using Mono to develop an specific purpose image browser to run on Windows, MAC/OS and Linux. To meet performance requirements the application requires a database to store thumbnails and search data. I am looking for suggestions for database products that run on Windows, MAC/OS and Linux that do not require use of technologies such as VMWare or Parallels, which I could use from within a Mono/C# environment. The application along with the database and the images will be distributed at no cost to "qualified" users, so I'm looking for a zero cost run time database system. The application must run stand-alone - i.e. no network, no servers, The thumbnails and search data would be imported from the original image files. The search data would be sourced from embedded IPTC metadata such as keywords and supplemental categories. The thumbnail and IPTC metadata are injected into the image files using a commercial Digital Asset Management (DAM) application. I don't insist that the "database" be SQL compliant, b-tree indexes would probably suffice. As long as the same database or index files can be used from within the same Mono application running on Windows, MAC/OS or Linux. TIA
I think MySQL or SQLite would be good choices. You could have a look at: Comparison of relational database management systems[^]
The need to optimize rises from a bad design.My articles[^]
-
I think MySQL or SQLite would be good choices. You could have a look at: Comparison of relational database management systems[^]
The need to optimize rises from a bad design.My articles[^]
Hi Mika, An earlier experience with MySQL was not a happy one so I'd more or less dismissed it, also like many of the others its overkill for my needs. However SQLite looks good, I like the idea of a using library rather than a separate process. Wonder if anyone's used in a Mono/C# app. I found this[^] nearby, it should get me off the ground. Thanks heaps - PhilD :-D
-
Hi Mika, An earlier experience with MySQL was not a happy one so I'd more or less dismissed it, also like many of the others its overkill for my needs. However SQLite looks good, I like the idea of a using library rather than a separate process. Wonder if anyone's used in a Mono/C# app. I found this[^] nearby, it should get me off the ground. Thanks heaps - PhilD :-D
urbane.tiger wrote:
However SQLite looks good, I like the idea of a using library rather than a separate process
Yeah, easy to implement and deliver. If you don't need a "byrocratic" installation, SQLite is most propably a good choice.
urbane.tiger wrote:
Wonder if anyone's used in a Mono/C# app
Based on a little search seems that it's been used at least a bit: http://www.google.com/search?hl=en&q=mono+c%23+sqlite&meta=&aq=f&oq=[^] Also this popped up: http://www.mono-project.com/SQLite[^] Mika
The need to optimize rises from a bad design.My articles[^]
-
urbane.tiger wrote:
However SQLite looks good, I like the idea of a using library rather than a separate process
Yeah, easy to implement and deliver. If you don't need a "byrocratic" installation, SQLite is most propably a good choice.
urbane.tiger wrote:
Wonder if anyone's used in a Mono/C# app
Based on a little search seems that it's been used at least a bit: http://www.google.com/search?hl=en&q=mono+c%23+sqlite&meta=&aq=f&oq=[^] Also this popped up: http://www.mono-project.com/SQLite[^] Mika
The need to optimize rises from a bad design.My articles[^]
Mika Wendelius wrote:
If you don't need a "byrocratic" installation, SQLite is most propably a good choice
Nuh, I prefer "graphitic" installs, they're much easier to rub out. Thanks for doing my research, I put myself on the ximian mailing lists earlier this evening. rgds PhilD