Manually add sqlite3 library to Libraries/Shared to import

Dev Community Dev/API Corner
1

The sqlite3 module has been sanboxed by plex, probably for good reason.

I would like to import either sqlite3 or pysqlite or mysql libraries to manipulate(dml) a db within my channel plugin.

So far I tried importing mysql but plex does not allow for the import of a sub module that is written in c.

Has anyone tried/used any solution to work with a sqlite3 db from within the pythin code.

Some history of what I’ve been trying: https://forums.plex.tv/discussion/261844/execute-javascript-using-pyv8

2

What do you need to manipulate in the database?

3

@dane22 said:
What do you need to manipulate in the database?

I’ve seen your replies in the past regarding this. That question is just bait for you to spew and make the plex devs happy.

I’m looking for a constructive answer. I don’t think you have one. Please stop shitting on my post.

I’m planning on bundling a .db in my channel plugin based on my channel design.

Please don;t give me “DICT” usage alternatives and your own thoughts. I have searched through the forum and have enough of them.

A soultion would be nice otherwise please move on man.

4

Wow…Having a bad day here?

I was simply asking, cuz maybe there’s an alternative using the API

5

@pimylifeup said:
Has anyone tried/used any solution to work with a sqlite3 db from within the pythin code.

Trakttv.bundle is the only one I know of. However, they have built the binaries for each platform and use a custom importing system so their channel can interact with Plex’s database and to remedy any ssl cert issues that comes with Plex’s builtin Python.

I did find a post here that gives a list of sql wrappers and some pure python based sql db. Maybe PyDbLite can handle your needs? Other than that, you’ll have to query the Trakt channel developer(s) about their channel and how they handle databases.

6

@Twoure said:

@pimylifeup said:
Has anyone tried/used any solution to work with a sqlite3 db from within the pythin code.

Trakttv.bundle is the only one I know of. However, they have built the binaries for each platform and use a custom importing system so their channel can interact with Plex’s database and to remedy any ssl cert issues that comes with Plex’s builtin Python.

I did find a post here that gives a list of sql wrappers and some pure python based sql db. Maybe PyDbLite can handle your needs? Other than that, you’ll have to query the Trakt channel developer(s) about their channel and how they handle databases.

Thank you. Will give your suggested solutions a spin.
Appreciate your time.