# \#sqlite

**URL:** https://discuss.hangfire.io/tag/sqlite/9.md

[Latest](https://discuss.hangfire.io/latest.md) · [Categories](https://discuss.hangfire.io/categories.md) · [Tags](https://discuss.hangfire.io/tags.md)

---

## [Run schedule job every N days](https://discuss.hangfire.io/t/run-schedule-job-every-n-days/10761)

<div class="topic-metadata">

**Author:** [@Giufra2009](https://discuss.hangfire.io/u/Giufra2009)\
**Replies:** 3\
**Last updated:** [June 18, 2024, 2:26am UTC](https://discuss.hangfire.io/t/run-schedule-job-every-n-days/10761 "2024-06-18T02:26:43Z")

</div>

Hello everyone, I need to find out if there is a solution with Hangfire to schedule a job every N days and every N hours and N minutes. The client (frontend) has three input boxes (days, hours and minutes) and a datepi…

---

## [Using Guid instead of Int as a Primary Key in BackgroundJob.Schedule](https://discuss.hangfire.io/t/using-guid-instead-of-int-as-a-primary-key-in-backgroundjob-schedule/10091)

<div class="topic-metadata">

**Author:** [@lyakabynka](https://discuss.hangfire.io/u/lyakabynka)\
**Replies:** 0\
**Last updated:** [July 13, 2023, 2:12am UTC](https://discuss.hangfire.io/t/using-guid-instead-of-int-as-a-primary-key-in-backgroundjob-schedule/10091 "2023-07-13T02:12:17Z")

</div>

Hello there. I am new to this forum. I would like to pose a questiong regarding using Guid instead of Int. To begin with, I am making a asp.net core project where users can schedule notifications. This notifications can…

---

## [Blocking: "An item with the same key has already been added. Key: LastJobId"](https://discuss.hangfire.io/t/blocking-an-item-with-the-same-key-has-already-been-added-key-lastjobid/9645)

<div class="topic-metadata">

**Author:** [@dantheman](https://discuss.hangfire.io/u/dantheman)\
**Replies:** 2\
**Last updated:** [January 3, 2023, 5:59pm UTC](https://discuss.hangfire.io/t/blocking-an-item-with-the-same-key-has-already-been-added-key-lastjobid/9645 "2023-01-03T17:59:36Z")

</div>

I am using Hangfire v1.7.31 and Hangfire.Storage.SQLite v0.3.2 in a self hosted windows service. After three days of solid running, I suddenly get this error on all my in-process HangFireServers (I run 4 in the same pr…

---

## [Many write access to Hangfire.db-journal](https://discuss.hangfire.io/t/many-write-access-to-hangfire-db-journal/9615)

<div class="topic-metadata">

**Author:** [@Benjamin\_Versini](https://discuss.hangfire.io/u/Benjamin_Versini)\
**Replies:** 2\
**Last updated:** [December 13, 2022, 2:37pm UTC](https://discuss.hangfire.io/t/many-write-access-to-hangfire-db-journal/9615 "2022-12-13T14:37:53Z")

</div>

Hi, I have a question, i have no JOB executer, in waiting or failed in Hangfire but i have many write access to the Hangfire.db-journal. How to reduce it ? I have the latest version of hangfire and SQLite connector in …

---

## [Which NuGet package is the better choice for SQLite storage?](https://discuss.hangfire.io/t/which-nuget-package-is-the-better-choice-for-sqlite-storage/9092)

<div class="topic-metadata">

**Author:** [@bhehe](https://discuss.hangfire.io/u/bhehe)\
**Replies:** 0\
**Last updated:** [April 14, 2022, 12:48pm UTC](https://discuss.hangfire.io/t/which-nuget-package-is-the-better-choice-for-sqlite-storage/9092 "2022-04-14T12:48:49Z")

</div>

I’m looking into adding Sqlite support to our ‘supported storage choices’ for Hangfire and I’m seeing there are 2 packages out there but none are ‘official’ from Hangfire itself. I’m curious which one is recommended bas…

---

## [Hangfire with Sqlite Storage executing multiple instances of recurring jobs](https://discuss.hangfire.io/t/hangfire-with-sqlite-storage-executing-multiple-instances-of-recurring-jobs/7620)

<div class="topic-metadata">

**Author:** [@skasliwal](https://discuss.hangfire.io/u/skasliwal)\
**Replies:** 3\
**Last updated:** [February 3, 2021, 4:28pm UTC](https://discuss.hangfire.io/t/hangfire-with-sqlite-storage-executing-multiple-instances-of-recurring-jobs/7620 "2021-02-03T16:28:52Z")

</div>

I am using SQLite as storage for Hangfire with default worker count of 20. I have a recurring job scheduled to run every 30 mins. Every 30 mins the job get executed but the recurring job triggered multiple times. When I …

---

## [Hangfire Support SQLLite?](https://discuss.hangfire.io/t/hangfire-support-sqllite/6610)

<div class="topic-metadata">

**Author:** [@drgk1991](https://discuss.hangfire.io/u/drgk1991)\
**Replies:** 1\
**Last updated:** [September 27, 2019, 11:14am UTC](https://discuss.hangfire.io/t/hangfire-support-sqllite/6610 "2019-09-27T11:14:54Z")

</div>

I would like to know, Hangfire support SQLLite ? If yes then which one is the recommended extension to use the Hangfire with the backend is SQLLite.

---

## [Need to get a failed jobs from hangfire database. ? is anyone having a idea about it?](https://discuss.hangfire.io/t/need-to-get-a-failed-jobs-from-hangfire-database-is-anyone-having-a-idea-about-it/6397)

<div class="topic-metadata">

**Author:** [@akshay](https://discuss.hangfire.io/u/akshay)\
**Replies:** 1\
**Last updated:** [July 26, 2019, 1:19pm UTC](https://discuss.hangfire.io/t/need-to-get-a-failed-jobs-from-hangfire-database-is-anyone-having-a-idea-about-it/6397 "2019-07-26T13:19:19Z")

</div>

Hi, I am using hangfire in sqlite for my project . i need to get all failed jobs . is there anyway to get it.? it ll be a great help for me to proceed . Thanks in advance.

---

## [Hangfire with local database .net core](https://discuss.hangfire.io/t/hangfire-with-local-database-net-core/5695)

<div class="topic-metadata">

**Author:** [@kivancbilen](https://discuss.hangfire.io/u/kivancbilen)\
**Replies:** 0\
**Last updated:** [December 24, 2018, 6:53am UTC](https://discuss.hangfire.io/t/hangfire-with-local-database-net-core/5695 "2018-12-24T06:53:31Z")

</div>

Hello all, I want to make an application which will work on linux and windows environments without any database, i tried to run sqlite version on .netcore webapi application but i couldn’t. Can anyone tried running sqli…

---

## [Dashboard: Cannot implicitly convert type 'long' to 'int?'. An explicit conversion exists (are you missing a cast?)](https://discuss.hangfire.io/t/dashboard-cannot-implicitly-convert-type-long-to-int-an-explicit-conversion-exists-are-you-missing-a-cast/3790)

<div class="topic-metadata">

**Author:** [@Adrian](https://discuss.hangfire.io/u/Adrian)\
**Replies:** 0\
**Last updated:** [September 13, 2017, 8:19am UTC](https://discuss.hangfire.io/t/dashboard-cannot-implicitly-convert-type-long-to-int-an-explicit-conversion-exists-are-you-missing-a-cast/3790 "2017-09-13T08:19:02Z")

</div>

Hi We are using Hangfire 1.6.16 with SQLite 1.4.1 backend. If the database is empty we can click in the Dashboard on the Jobs-Tab and see the jobs list (all is empty). As soon as we have enqued a long running job and the…

---

## [Hangfire in .NET Core Cross Platform App using Sqlite](https://discuss.hangfire.io/t/hangfire-in-net-core-cross-platform-app-using-sqlite/3742)

<div class="topic-metadata">

**Author:** [@jakesmith](https://discuss.hangfire.io/u/jakesmith)\
**Replies:** 2\
**Last updated:** [August 27, 2017, 8:13pm UTC](https://discuss.hangfire.io/t/hangfire-in-net-core-cross-platform-app-using-sqlite/3742 "2017-08-27T20:13:52Z")

</div>

Tried the various third party Sqlite extensions for Hangfire in a .NET Core application meant for cross platform use, and they don't work or not recommended for Production according to their authors. https://github.co…

---

## [Storage configuration](https://discuss.hangfire.io/t/storage-configuration/634)

<div class="topic-metadata">

**Author:** [@canning\_s](https://discuss.hangfire.io/u/canning_s)\
**Replies:** 4\
**Last updated:** [August 17, 2015, 1:46am UTC](https://discuss.hangfire.io/t/storage-configuration/634 "2015-08-17T01:46:27Z")

</div>

Hi, When using Hangfire, is it possible to use xml files rather than SQL Server storage? I am thinking on the same lines as ELMAH, where the data is stored in App\_Data, rather than a database. Is this possible? Tha…
