31 replies to this topic

[mrdude]

Yep it was a pain, I was looking at my code for a couple of days wondering why it wouldn't work - when there was nothing wrong with it. What else I notice is that sometimes when you write some code that 'should' work, you get an error such as a screen modal error or something else, sometimes I need to put in a few milliseconds delay before the code gets executed, and then it works fine - god only knows why???

 

Anyway it's all sorted now - thanks for your help.

 

Now I am on to learning about sqlite3 so I can add some favourites in a database as this is probably the best way to store data for a multi-content page. Ahh the joys of leaning a new language, and enigma2 (without hardly any decent documentation).

[mfaraj57]

Yes,till now when use  yellow button to add item to favourites.xml in TSmedia,the item added twice,this happened only with openvix and openatv ,i reviewed the code more than hundreds times without explanation,then to solve the problem i added block to add the same item twice.

unfortunately no good documentation and examples for enigma part programming while there is extensive references for python part

never used sqlite3 to store data and never seen it in any plugin apart from kodi plugins and i think will not easy and will be slow for enigma receivers ,expect xml methods are faster and easier  but I am sure about this comparison

Edited by mfaraj57, 17 July 2017 - 15:39.

[mfaraj57]

May to look for kodi plugins for using sqlite3 ,kodi plugins written purely with python.

[mrdude]

If you look the the internet radio plugin this uses sqlite, it's better and faster to store lots of data in a database, also it can be read from an online website or local quite easily - plus it's easy to search through and sort the data. That's probably when nearly all websites use them. Enigma2 can handle sqlite3 quite easily.

 

Example and guide here: https://pythonschool.../databases.html

 

I just tried it on enigma2 and it was pretty easy to make the database and tables, really all I need to do is read some info which I already know how to do, then save that info to a database, then populate another page with that info.

 

I plan an getting links from various iptv servers - then store them in the database so I can view them/removeand add them easily.

[mrdude]

Well I used sqlite3 in the end and it's very fast, also it's easy to use mod or use the database in other programs/plugins.

 

[WanWizard]

We used Sqlite in the old Enigma1 days for EPG data, on "crap" hardware like the DM7000, with success. So todays hardware shouldn't have a problem with it at all.

[mfaraj57]

good,may use it to store favorites links in TSmedia instead storing to xml file.

[WanWizard]

If it was up to me, all info goes into a database, from configuration to epg data to satellites.xml. It is the only way to get proper data consistency.

[mfaraj57]

may be except satellites.xml because it is universal and easy to edit for user

[WanWizard]

Which is exactly what I want to avoid.

[MiLo]

We used Sqlite in the old Enigma1 days for EPG data, on "crap" hardware like the DM7000, with success. So todays hardware shouldn't have a problem with it at all.

Today's settop boxes are way more powerful than the room-filling database servers I used to work with... You don't have to stick to sqlite, fullblown transactional databases will run fine.
The real issue is the software... We've talked about that before.

[WanWizard]

I remember those.

 

For our purposes I prefer not to go with Sqlite, as you would want to be able to create something multiuser/distributed.

 

In the end it's always software. And someone with the desire and motivation to dive in and deal with all the spaghetti.