# Save conversation sqlite

**URL:** <https://forum.rasa.com/t/save-conversation-sqlite/19758>\
**Category:** Rasa Open Source\
**Created:** [October 14, 2019, 10:40am UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758 "2019-10-14T10:40:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![OUHIBIadel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/ouhibiadel/32/3359_2.png) [@OUHIBIadel](https://forum.rasa.com/u/OUHIBIadel)\
**Post date:** [October 14, 2019, 10:40am UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/1 "2019-10-14T10:40:43Z")

</div>

@souvikg10 @abhishakskilrock

hi

i like to save conversations in a sqlite database,

this is what i put in endpoints:

```auto
tracker_store:
    type: SQL
    dialect: "sqlite" # the dialect used to interact with the db
    url: # (optional) host of the sql db, e.g. "localhost"
    db: "rasa.db" # path to your db
    username: # username used for authentication
    password: # password used for authentication
    # query: # optional dictionary to be added as a query string
      # driver: my-driver

```

and this is my agent, in run\_app file:

```auto
Interpreter = RasaNLUInterpreter("./models")
MODEL_PATH = "./models"
ActionEndpoint = EndpointConfig(url="http://localhost:5055/webhook")
db = SQLTrackerStore(domain="domain.yml", dialect="sqlite", db="rasa.db",username="",password="")

agent = Agent.load(MODEL_PATH, interpreter=Interpreter,
                   action_endpoint=ActionEndpoint,tracker_store=db)

```

i cant find conversations in rasa.db file ☹

Could you help me please, knowing that i use only rasa (without rasax)

Thank you and have a good day

---

<div class="post-metadata">

**Author:** ![btotharye](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/btotharye/32/5321_2.png) [@btotharye](https://forum.rasa.com/u/btotharye)\
**Post date:** [October 17, 2019, 1:47pm UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/2 "2019-10-17T13:47:37Z")

</div>

I’m still looking into this but I did this and it works ok for me and creates the rasa.db file. I haven’t setup the custom stuff there yet in that run\_app file you are referencing tho, is this your action server code or what is that?

---

<div class="post-metadata">

**Author:** ![OUHIBIadel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/ouhibiadel/32/3359_2.png) [@OUHIBIadel](https://forum.rasa.com/u/OUHIBIadel)\
**Post date:** [October 18, 2019, 7:59am UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/3 "2019-10-18T07:59:50Z")

</div>

Hi @btotharye

run\_app.py is the SocketIO channel configration file.

I think that tracker\_store depend on rasa x, could you confirme this?

---

<div class="post-metadata">

**Author:** ![btotharye](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/btotharye/32/5321_2.png) [@btotharye](https://forum.rasa.com/u/btotharye)\
**Post date:** [October 18, 2019, 8:39am UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/4 "2019-10-18T08:39:29Z")

</div>

Yes the tracker store is a requirement for Rasa X and you can pick which one you want to setup, if you don’t select one it should default to the InMemoryTrackerStore

[Tracker Stores](https://rasa.com/docs/rasa/api/tracker-stores/#id1) for info about those

---

<div class="post-metadata">

**Author:** ![OUHIBIadel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/ouhibiadel/32/3359_2.png) [@OUHIBIadel](https://forum.rasa.com/u/OUHIBIadel)\
**Post date:** [October 21, 2019, 4:06pm UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/5 "2019-10-21T16:06:17Z")

</div>

i use sqlite\_tracker\_store withou installing rasax, not the inv.

Thank you @btotharye, anyway

---

<div class="post-metadata">

**Author:** ![abhishakskilrock](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/abhishakskilrock/32/4039_2.png) [@abhishakskilrock](https://forum.rasa.com/u/abhishakskilrock)\
**Post date:** [November 8, 2019, 5:46am UTC](https://forum.rasa.com/t/save-conversation-sqlite/19758/6 "2019-11-08T05:46:45Z")

</div>

Did this solution resolved the problem?