Welcome to our forums! Please take a few moments to read through our Community Guidelines (also conveniently linked in the header at the top of each page). There, you'll find guidelines on conduct, tips on getting the help you may be searching for, and more!

Manually add sqlite3 library to Libraries/Shared to import

pimylifeuppimylifeup Posts: 12Members ✭✭

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

Best Answer

Answers

  • dane22dane22 Posts: 9,688Members, Plex Pass, Plex Ninja Plex Ninja

    What do you need to manipulate in the database?

  • pimylifeuppimylifeup Posts: 12Members ✭✭

    @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.

  • dane22dane22 Posts: 9,688Members, Plex Pass, Plex Ninja Plex Ninja

    Wow.....Having a bad day here?

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

  • pimylifeuppimylifeup Posts: 12Members ✭✭

    @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.

Sign In or Register to comment.