# Logstash SQLite input without write permission to database

**URL:** <https://discuss.elastic.co/t/logstash-sqlite-input-without-write-permission-to-database/51969>\
**Category:** Logstash\
**Created:** [June 6, 2016, 3:08pm UTC](https://discuss.elastic.co/t/logstash-sqlite-input-without-write-permission-to-database/51969 "2016-06-06T15:08:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yannakopoulos](https://avatars.discourse-cdn.com/v4/letter/y/ecc23a/32.png) [@yannakopoulos](https://discuss.elastic.co/u/yannakopoulos)\
**Post date:** [June 6, 2016, 3:08pm UTC](https://discuss.elastic.co/t/logstash-sqlite-input-without-write-permission-to-database/51969/1 "2016-06-06T15:08:17Z")

</div>

I have an SQLite database I'd like to read in real time, but I won't have write permissions to it.

From what I understand, the SQLite input plugin needs to create the equivalent of other input method's `.sincedb` files inside the database I'm trying to read. I could make a copy of the database to my own directory every so often, thus giving me write permission, but this would override the `.sincedb` equivalent and make Logstash reread all my data from the top, right? Is there a workaround to this?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:54am UTC](https://discuss.elastic.co/t/logstash-sqlite-input-without-write-permission-to-database/51969/2 "2017-07-06T04:54:26Z")

</div>