[Core feature] Flyteadmin support for sqlite3

[kumare3]

Motivation: Why do you think this is important?

Currently to start sandbox flyteadmin needs a postgres server. GORM supports sqlite3 and this should be possible to use with flyteadmin

GORM support: https://gorm.io/docs/connecting_to_the_database.html#SQLite

Goal: What should the final outcome look like, ideally?

if i start flyteadmin locally, it should be possible to start with a sqlite db . This would speed up testing and starting up of flyteadmin.
Similarly we can do the same for datacatalog

Describe alternatives you've considered

start a postgres server

Propose: Link/Inline OR Additional context

No response

Are you sure this issue hasn't been raised already?

• Yes

Have you read the Code of Conduct?

• Yes

[NikeNano]

I would be happy to work on this, will start to take a look at it.

[kumare3]

The database can be set to sqlite3 using

database:
  sqlite:
    file: admin.db

And the best way to work on this is to use the single binary development
the local config is here -

flyte/flyte_local_k3d.yaml

Lines 27 to 33 in 5f801cd

	database:
	postgres:
	port: 30089
	username: postgres
	host: localhost
	dbname: flyteadmin
	options: "sslmode=disable"

And you can setup a local development environment using

flyte/Makefile

Lines 88 to 89 in 5f801cd

	setup_local_dev: ## Sets up k3d cluster with Flyte dependencies for local development
	@bash script/setup_local_dev.sh

To modify Admin code and check it locally, I usually add a go replace

flyte/go.mod

Line 221 in 5f801cd

replace github.com/robfig/cron/v3 => github.com/unionai/cron/v3 v3.0.2-0.20210825070134-bfc34418fe84

replace github.com/flyteorg/flyteadmin => ../flyteadmin

[katrogan]

this is an incredibly stale PR, but this is how far we made it last time trying to get sqlite in admin working: flyteorg/flyteadmin#374

[github-actions]

Hello 👋, This issue has been inactive for over 9 months. To help maintain a clean and focused backlog, we'll be marking this issue as stale and will close the issue if we detect no activity in the next 7 days. Thank you for your contribution and understanding! 🙏

[github-actions]

Hello 👋, This issue has been inactive for over 9 months and hasn't received any updates since it was marked as stale. We'll be closing this issue for now, but if you believe this issue is still relevant, please feel free to reopen it. Thank you for your contribution and understanding! 🙏

[github-actions]

Hello 👋, this issue has been inactive for over 9 months. To help maintain a clean and focused backlog, we'll be marking this issue as stale and will engage on it to decide if it is still applicable.
Thank you for your contribution and understanding! 🙏