Export odoo database to sqlite in cronjob

It is possible to create a cronjob in Odoo to export specific tables of the database to sqlite? I want to create a automated task that takes some specific tables of a module and them export it to a sqlite file

Solution

Try below Odoo module

https://apps.odoo.com/apps/modules/12.0/base_external_dbsource_sqlite/

Configuration described in module itself.

How do I DELETE with WHERE and IN using a composite primary key?
Checking if a value exists in database
MissingGreenlet: greenlet_spawn has not been called
Overlay table mechanism in SQLite
Insert or update when importing from JSON
How can I make SELECT return a pre-defined string instead of a boolean (integer)?
DLLNotFoundException (e_)sqlite3
How to retrieve the last autoincremented ID from a SQLite table?
Sqlite In-memory database does not like a two phase commit
Combining the result of two queries using SQLite
Utilizing Sqlite `no such table` error in Go?
Operational Error in Cursor Method Execute
Arcpy seems to not carry out my SQL clause
Create table using SQLite in WinRT: BadImageFormatException
Python insert UTF8 string into SQLite
Is there a product operator (or work around) in SQLite?
How to make Room work with "pre-packaged" databases with different schemas?
How to fix `no such table` error with SQLite
How to obtain a boolean out of a SQL WHERE condition?
How do I repeat a SQL query over a set of records?
How can I find conflicting rows with multiple unique columns between 2 tables in sqlite?
Reading back a datetime in sqlite3
What row gets selected when you GROUP BY without aggregate function?
What if I don't close the database connection?
How to get data from INSERT...RETURNING * in node.js sqlite3
Enable Query Logging in SQLite 3
Rounding to nearest or up in SQLite
How do I check whether a database exists?
Select random row(s)
Select first row in each group using GROUP BY