# Suggested SQLite3 DB Optimizations

**URL:** <https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749>\
**Category:** Plex Media Server\
**Tags:** server-linux\
**Created:** [May 29, 2022, 3:20am UTC](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749 "2022-05-29T03:20:42Z")\
**Posts on this page:** 3\
**Page:** 8

<div class="post-metadata">

**Author:** ![esilberberg](https://avatars.discourse-cdn.com/v4/letter/e/b5ac83/32.png) [@esilberberg](https://forums.plex.tv/u/esilberberg)\
**Post date:** [March 13, 2023, 5:10pm UTC](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749/146 "2023-03-13T17:10:12Z")

</div>

I know there are a billion docker images, but for folks with binhex-plexpass here’s an ugly but effective discovery module check. I dropped it after the docker check and before the #Unknown.

# BinHexDocker

elif [-f /usr/lib/python3.10/binhex.py] && [-f “/etc/arch-release”]; then

```
PLEX_SQLITE="/usr/lib/plexmediaserver/Plex SQLite"
AppSuppDir="/config/Library/Application Support"
PID_FILE="$AppSuppDir/Plex Media Server/plexmediaserver.pid"
DBDIR="$AppSuppDir/Plex Media Server/Plug-in Support/Databases"
LOGFILE="$DBDIR/DBRepair.log"
LOG_TOOL="logger"

HostType="BinhexDocker"
return 0

```

fi

---

<div class="post-metadata">

**Author:** ![ChuckPa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/chuckpa/32/79710_2.png) [@ChuckPa](https://forums.plex.tv/u/ChuckPa)\
**Post date:** [March 13, 2023, 5:37pm UTC](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749/147 "2023-03-13T17:37:53Z")

</div>

@esilberberg

Feel free to join us over in the development thread.  
Binhex is already a supported container but I do like your approach (more definitive)

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [June 11, 2023, 5:38pm UTC](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749/148 "2023-06-11T17:38:42Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

[Previous page](https://forums.plex.tv/t/suggested-sqlite3-db-optimizations/794749.md?page=7)