Remove the memory option for database URL

[pmeier]

After #205, the config is no longer in use for the Python API. Thus, we can just use a local sqlite instance as default to have persistence. Users can still select an ephemeral in-memory database by using sqlite:// as option.

Here are some places where changes need to happen

• Config wizard
  

  ragna/ragna/deploy/_cli/config.py

  Lines 254 to 265 in 2c1e5c4

  	if questionary.confirm(
  	"Do you want to use a SQL database to persist the chats between runs?",
  	default=True,
  	qmark=QMARK,
  	).unsafe_ask():
  	config.api.database_url = questionary.text(
  	"What is the URL of the database?",
  	default=f"sqlite:///{config.local_cache_root / 'ragna.db'}",
  	qmark=QMARK,
  	).unsafe_ask()
  	else:
  	config.api.database_url = "memory"

• REST API
  

  ragna/ragna/deploy/_api/core.py

  Lines 105 to 108 in 2c1e5c4

  	database_url = config.api.database_url
  	if database_url == "memory":
  	database_url = "sqlite://"
  	make_session = database.get_sessionmaker(database_url)

• REST API tests
  

  ragna/tests/deploy/api/test_e2e.py

  Lines 12 to 15 in 2c1e5c4

  	@pytest.mark.parametrize("database", ["memory", "sqlite"])
  	def test_e2e(tmp_local_root, database):
  	if database == "memory":
  	database_url = "memory"

[pmeier]

@nenb I think you requested this somewhere, but I can't find it. If this is still in open issue, please x-ref this here.