Made a new thing.

[helpstertee@social.helpsterte.eu]

@lashman@mastodon.social looks good! (couldn’t test)

Maybe you could consider adding Flatpak / Flathub support, that would give you access to a lot of Linux users. As all you do is interact with the SQLite you can really restrict the Flatpak, which will make it less scary on the Flathub interface.

Also it’s not a bad idea to add "100% human crafted code" these days, if it applies :D

[lashman@mastodon.social]

@helpsterTee ohhh, i would LOVE to add linux and even mac versions, but i don't really have anything to compile (or test) those in sadly :( so it'll have to stay windows-only for now :(

[helpstertee@social.helpsterte.eu]

@lashman@mastodon.social with Linux you could just try on a VM…Apple sucks with their $99 annual dev subscription :/
Or maybe someone else can maintain, but then it’s unofficial.

Nevertheless, congrats on release :)

[lashman@mastodon.social]

@helpsterTee yeah, that's fair, but vm isn't entirely the same thing, sadly :( especially when it comes to performance. but i will consider it, might have to!

and thank you, appreciate it! :)

[autiomaa@mementomori.social]

@lashman That looks awesome based on the documentation and screenshots. Especially like that everything is stored on a SQLite database file, allowing people to use existing database tools for potential future integrations to other tools and workflows.

Simon Willison's Python-based Datasette https://datasette.io tools could be used to turn that SQLite file to optional browser-based UI that allows query building and enables APIs for integrating SQLite databases to existing applications. It has been used for both personal databases and for business usage.

[lashman@mastodon.social]

@autiomaa thank you! :) and yeah, that sounds really cool! :D

[hyperlinkyourheart@mastodon.ie]

@lashman That looks really slick 👍

[lashman@mastodon.social]

@hyperlinkyourheart thank you! :)

[argentum@mas.to]

@helpsterTee @lashman maybe to start with it could be available for Mac via homebrew? Seems easier once you get the Linux bit working

[dergell@mastodon.gamedev.place]

@lashman trying it out right now and I must say, I'm impressed! Thank you for creating this, especially for free.

Question: I tried to import a detailed Clockify CSV. It throws "Error: RangeError: Invalid time value". Do you have documentation somewhere, so I can fix the file myself? Can I help you in any way with logs or anything?

[lashman@mastodon.social]

@dergell no problem! :) and i'll see what i can do about the import, thanks for letting me know about this, i'm on it! :)

[lashman@mastodon.social]

@dergell ok, i thiiiink i found the bug (hopefully, fingers crossed!), so try this one and let me know, please: https://git.lashman.live/lashman/zeroclock/releases/tag/v1.0.1

and sorry about that

[dergell@mastodon.gamedev.place]

@lashman well, that was quick! It worked, good job. Thank you very much and please don't apologize, you are doing this on a Saturday after all :D

[lashman@mastodon.social]

@dergell it did? WOOHOO!!! :) thank you so much :D and it's no problem, really :) i'm just glad it actually works, haha

[autiomaa@mementomori.social]

@lashman Take a look at Datasette core tools https://datasette.io/tools and plugins https://datasette.io/plugins that enable cool things like data visualisation and integrations to 3rd party systems. All on top of your file-based SQLite databases.

You could (for example) do matching between Git commits and time tracking by importing multiple SQLite databases to Datasette. Then it would be possible to do SQL queries to both and visualize the outputs with various existing tools it has available. Datasette has importers from various SaaS platforms (including GitHub), allowing to do data analysis and archives to a local system.

[lashman@mastodon.social]

@autiomaa i will check it out, for sure, thanks! :D

[dergell@mastodon.gamedev.place]

@lashman I've tested some more and found an issue with the date structure. I've checked the database and found, for example, an entry with a start date of February 12th has been imported as '2026-12-02T14:00:00'. Seems the month and day is flipped.

[lashman@mastodon.social]

@dergell hmmm, i think i know why that is, lemme dig into the code again :) thanks

[lashman@mastodon.social]

@dergell oooook, that one's DEFINITELY on me, oops :P apologies again

https://git.lashman.live/lashman/zeroclock/releases/tag/v1.0.2

[dergell@mastodon.gamedev.place]

@lashman That seems to have solved it. Will test some more and let you know if I find anything else. Thanks!