Database (1 Viewer)

[sf1]

What type of database mp2 currently use?

Is there any possibility to export data to mysql?

If yes, it would be possible to make relative easy web interface with php and script backround and html5 support.

 

[Lehmden]

Hi.
At the moment there are 3 DB plugins (SQLCE, SQLite3 and MySQL) from which the user can choose one (only one). As per default MP2 uses SQLite3 Database. It's faster (a lot!) than MySQL and don't need a full blown DB server running just to serve one Database. SQLCE was there from the very first beginning but isn't developed any longer as it's slow (compared to MySQL and SQLite) and has size limits for DB...

If you want, you can access SQLite by PHP as easy as MySQL.
http://www.php.net/manual/en/book.sqlite3.php

But, that's not what is wanted, a direct DB access. As Users can change DB you never know which DB is used at all. All changes made on DB should be delivered by MP2 Server, not by direct access... Nevertheless if you write direct Web Access you need to be sure, the user didn't change type, path or name of the DB....

 

[sf1]

Thank you for your response.
It is perfect if php can access to sqlite3
What do I need is the beginning of your Media portal so not to have problems to import media, imdb ... structure ...
I do not want clients - only one client at local server for configuration.
I need web output which will use html5 - it will be perfect for ipad and androind, linux, windows ...and it do not use too much procesor time, because of no transcoding. video will be prepared before to be used for html5

So I will make a combination of MediaCenter for preparing medias and web portal, because streeming video is solved by special server.

It is not problem with database change, because users will have only limited possibility for configuration on web.
I am going to make something like DS video on Ipad.

The problem may be only if you change database structure after upgrade, but i can test it before.

I hope that plugins will not change existing database tables, only add some new. Do you have a rule for it?

I thought to use mythbuntu, but at present it has too many bugs :-( and looks like not to be developed ... similar projects like mythdora has been stoped :-(

Media Portal 2 is only alfa , but it function Good job.

 

[Lehmden]

Hi.

I am going to make something like DS video on Ipad.

Sounds like something we all could use widely. A bridge between the WIndows only MediaPortal2 and all the mobile devices out there..

if you change database structure

At the moment our devs are busy on an importer rework, what definitely brings up some changes to the DB. So if you want to develop something, you best talk to @morpheus_xx or @MJGraf prior to that, just to avoid double work...
Maybe you can find a way to work together so we all can benefit from this...

Media Portal 2 is only alfa , but it function

This is a good tradition on the whole MediaPortal thing. Our Beta versions often are more stable than most other "final" versions....

 

[sf1]

Is it SQLite3 database? I am trying to open it in sqlite manager, but it is not possible - encrypted or different format.

 

[Lehmden]

Hi.
It is definitely SQLite3 database as long as you don't have changed the DB plugin by yourself. I can open it in SQLite Expert Personal without any issues. As long as you don't change default path it is in "...ProgramData\Team MediaPortal\MP2-Server\Database\datastore.s3db"

P.S. if you have a very old version of MP2 then it can be SQLCE. But if you install Alpha4 (most recent public version) then it is SQLite3.

 

[MJGraf]

Is it SQLite3 database

Yes, it is - and unless your particular database is actually corrupted, it should be possible to open it in sqlite manager.

Apart from that - and first of all - thank you for digging into the MP2 codebase! One thing I should mention before you start programming: It is not intended to directly access the database. The database structure may change at any time - not only if the core of MP2 changes, it may also happen if you just install another plugin. The only (supported) way of accessing the database is through the MediaLibrary class which takes care of all the database background. Of course you are free to chose whatever way you like to access the content of our MediaLibrary - I just wanted to mention this to avoid that you are disappointed if something changes that breaks your plugin (may happen very frequently in the near future due to the rework that Lehmden mentioned)