MP2 Database info + tools (1 Viewer)

[Pog]

For those users like myself that want to check out the internals of the new database here are some useful resource links...

The main bits you need are the Database viewer and MS runtime (for x64 install both the 32 and 64 bit runtimes).

Wiki: http://en.wikipedia.org/wiki/SQL_Server_Compact

Database Viewer: http://sourceforge.net/p/compactview/home/Home/

Info+Resources: http://erikej.blogspot.com/

MS runtime: http://www.microsoft.com/download/en/details.aspx?id=5783

 

[Albert]

Are you reverse engineering our MediaLibrary, hm?

 

[Pog]

I like to play with the box more then the toy.

Actually after installing and setting up the alpha I went to look at the data folder and it was almost empty and I was wondering how the new system worked.

 

[guytpetj]

Database Viewer: http://sourceforge.net/p/compactview/home/Home/

This program has the same snag MP2 has/ and for me had. Will not handle databases that exceed 256MB.
I'll contact the programmer to see if he can modify the software to allow for larger databases.

 

[Smeulf]

Or you have SQL Manager with SLQ Express that can handle those databases with the proper SQLCE modules...

 

[joemorin73]

Is it potential to store the database in an SQL server database? as opposed to SQLCE?

 

[Smeulf]

Well joemorin, even if technically speacking, it should be possible to write a plugin to use MsSQL (or any other db engine) instead of SQL CE, we choose SQL CE because it does not require any component but the DLLs provided with MP2. This way, there is no database server running in the background.

It's a design choice, and I don't think we'll move the database to SQL Server or any other one...

 

[joemorin73]

Do not get me wrong. I do agree SQLCE, SqlLite or similar is perfect for single seat setups. If the layer is completely encapsulated in a plugin, than it can be changed to any database.

I have some question on development plugins, but I'll leave that for another post in the correct section.

 

[Albert]

The database layer is completely flexible. MP2 sets some requirements on the underlaying database, which can be fulfilled by most of the common databases like MSSQL server. It is quite easy to exchange the SQLCE plugin.

 

[guytpetj]

The programmer of CompactView has been so kind to fix the 256MB database limit bug, the same bug we identified in MP2 and than also found in his program.

2012/03/08 v1.3.3 Redesign of the CompactView icon. Fix bug: Error opening databases bigger than 256MB.
http://sourceforge.net/projects/compactview/files/CompactView_1.3.3/