Zeitpunkt Nutzer Delta Tröts TNR Titel Version maxTL Do 18.07.2024 09:31:02 61.956 -1 3.554.451 57,4 Fosstodon 4.2.10 500 Mi 17.07.2024 22:00:27 61.957 +1 3.553.476 57,4 Fosstodon 4.2.10 500 Di 16.07.2024 22:01:10 61.956 -1 3.550.157 57,3 Fosstodon 4.2.10 500 Mo 15.07.2024 22:00:36 61.957 +6 3.547.999 57,3 Fosstodon 4.2.10 500 So 14.07.2024 22:00:01 61.951 +1 3.544.794 57,2 Fosstodon 4.2.10 500 Sa 13.07.2024 22:00:00 61.950 +2 3.542.390 57,2 Fosstodon 4.2.10 500 Fr 12.07.2024 22:00:08 61.948 +1 3.539.632 57,1 Fosstodon 4.2.10 500 Do 11.07.2024 22:01:45 61.947 +6 3.537.376 57,1 Fosstodon 4.2.10 500 Mi 10.07.2024 22:00:37 61.941 +12 3.533.951 57,1 Fosstodon 4.2.10 500 Di 09.07.2024 22:00:53 61.929 0 3.530.507 57,0 Fosstodon 4.2.10 500
Andreas (@mozzo) · 05/2023 · Tröts: 18 · Folger: 7
Do 18.07.2024 19:10
With the awesome tool sqlite-utils by @simon (thank you!). It made everything so easy from insertion to querying the database while I was testing things out.
Like literally two commands and you are good to go,
`sqlite-utils insert DB_NAME DB_TABLE CSV_FILE --csv`
and
`sqlite-utils enable-fts DB_NAME DB_TABLE [COLUMNS]`
> https://sqlite-utils.datasette.io/en/stable/cli.html
3/?
[Öffentlich] Antw.: 0 Wtrl.: 0 Fav.: 0