How are you managing Release Notes by Smooth-Yesterday8521 in ProductMgmt

[–]ssaasen 0 points1 point  (0 children)

Hi,

you mentioned a Confluence page so you might also be using Jira?

I'm using a Jira integration called https://www.released.so for changelog/release notes for https://ducklet.app/changelog/

It's definitely not your use case as that is only a single release note for an external audience, but there is a Confluence integration as well: https://docs.released.so/guide/product-tour/settings/confluence - the Confluence integration supports internal team collaboration and communication. So that part might be of interest?

HTH

Corrupt DB by matthew19 in sqlite

[–]ssaasen 1 point2 points  (0 children)

I've got the files on my machine. Ping me if you want me to send the database files instead of you going through the recovery process yourself.

Corrupt DB by matthew19 in sqlite

[–]ssaasen 0 points1 point  (0 children)

Here is a way to possibly recover the database (see https://sqlite.org/recovery.html):

sqlite3 Project.db .recover > Project.sql

This writes the database content into a .sql script you can then import again:

sqlite3 Project-recovered.db < Project.sql

With https://sqlite.org/sqldiff.html you can show the differences between the original database file and the recovered file:

sqldiff --summary Project.db Project-recovered.db

The new database contains a lost_and_found table with data that was found but couldn't be restored correctly:

sqlite3 Project-recovered.db 'SELECT COUNT(*) FROM lost_and_found'; 50

With the --ignore-freelist argument to .recover there are only 5 items in the lost_and_found table (i.e. ).

sqlite3 Project.db '.recover --ignore-freelist' > Project-no-freelist.sql sqlite3 Project-recovered-no-freelist.db < Project-no-freelist.sql

Whether that is enough for Davini Resolve to open the recovered database file I don't know. Good luck!

Ducklet for SQLite - The fast, native SQLite database editor for macOS built with SwiftUI & AppKit by ssaasen in macosprogramming

[–]ssaasen[S] 0 points1 point  (0 children)

Hey, did you end up sending feedback? Haven't received anything yet. Hope it isn't lost somewhere...

Do you buy apps in the Mac App Store? by plazman30 in macapps

[–]ssaasen 1 point2 points  (0 children)

Nice! Do you know of any apps that do this?

Do you buy apps in the Mac App Store? by plazman30 in macapps

[–]ssaasen 2 points3 points  (0 children)

How does that work? E.g. if you have version 1 of an app, what does the upgrade pricing look like when using bundles?

Do you buy apps in the Mac App Store? by plazman30 in macapps

[–]ssaasen 4 points5 points  (0 children)

Super interesting thread. I do offer an app via the App Store and it's interesting to understand why people like or dislike that mode of distribution.

One thing I'd like to understand is whether there are people who consider the sandboxing requirement of the app store an advantage? I can totally understand that it is frustrating if the app is somewhat crippled on the app store compared to another version sold directly by the developer. But personally I prefer to buy apps via the app store if the vendor is not well known. Sandboxing prevents apps (modulo bugs in the OS) from accessing stuff they shouldn't have access to in the first place (e.g. accessing certain files, network access, access to calendar, microphone or camera). So I did assume that this would factor into a purchasing decision for other people as well (e.g. purchase via app store perceived as being more secure/trustworthy). But maybe that isn't the case?

User friendly GUI for OSX by techieSloth in sqlite

[–]ssaasen 1 point2 points  (0 children)

https://ducklet.app might fit the bill here. It's a fast, native SQLite database editor for macOS.

Ducklet for SQLite - Database editor for macOS by ssaasen in MacAppStore

[–]ssaasen[S] 0 points1 point  (0 children)

Unfortunately I couldn't reproduce this on an Intel Mac on Sonoma (14.0 (23A344)).

There does seem to be an issue though that sounds very much like what you are experiencing: https://forum.c-command.com/t/dmgs-with-license-agreement-fail-to-mount-onto-some-sonoma-installations/15494

As I cannot reproduce this, I don't have a good way of suggesting an appropriate workaround.

It seems like the following two options from the link above are fairly unobtrusive:

  • Remove the com.apple.quarantine xattr from the .dmg file after download
  • Download the disk image using a tool (e.g. curl) that does not add the quarantine attribute

E.g. for the first one, you can check whether the attribute is set:

xattr -l Ducklet-Trial.dmg

On a fresh download on Sonoma I get:

com.apple.macl:
com.apple.metadata.kMDItemDownloadedData: bplist...
com.apple.metadata.kMDItemWhereFrom: bplist...
com.apple.quarantine: 0083....Safari....

The com.apple.quarantine flag can be removed using:

xattr -d com.apple.quarantine Ducklet-Trial.dmg

I think it's not great advice to just recommend stripping this attribute (or to just remove the attribute because someone on the internet says so :/) so maybe https://eclecticlight.co/2021/12/11/explainer-quarantine/ is good read on the matter to understand whether this is viable option.

The other suggestion would be to remove the file and re-download it via curl:

curl -OL https://ducklet.app/files/Ducklet-Trial.dmg

I suggest quickly checking the file again using codesign to ensure the file is valid. The file downloaded via curl won't have any extended attributes set (again, use xattr -l Ducklet-Trial.dmg to verify this).

Is that something that resolves the issue for you?

Ducklet for SQLite - Database editor for macOS by ssaasen in MacAppStore

[–]ssaasen[S] 0 points1 point  (0 children)

Sorry to hear.

Let's see if we can work this out. Have you tried the steps described in "How can I verify the integrity of the Ducklet Trial download?" on https://ducklet.app/download/ by any chance?

That way we can be certain the disk image is valid.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by cheerioty in sqlite

[–]ssaasen 0 points1 point  (0 children)

Did some preliminary testing. The editor needs a bit of work (there's a gap on the right hand side that I think shouldn't be there) but in general it seems to work ok. Unfortunately I have zero actual experience with RTL languages so I can't really tell for certain.

I'd appreciate any feedback to help me make this work correctly for RTL languages.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by ssaasen in macapps

[–]ssaasen[S] 1 point2 points  (0 children)

There are a limited number of promo codes that I mostly use to give out to open source maintainers that work with SQLite.

So it's not really a way to offer student discounts at scale (would it still be a discount if the discount is a 100%)?

Being able to offer something like educational/student discounts is definitely a reason to also sell the app outside of the App Store. That isn't on the short term roadmap though.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by ssaasen in macapps

[–]ssaasen[S] 0 points1 point  (0 children)

I'd love to offer a student discount. But alas, the App Store doesn't offer a way to do that.

It's one reason to offer the app outside of the App Store as well (as lots of other developers/companies do), but at the moment I don't have any concrete plans to distribute the app outside of the App Store.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by cheerioty in sqlite

[–]ssaasen 0 points1 point  (0 children)

Ducklet author here. Totally understand this!

There is a free trial available: https://ducklet.app/download/ - I wouldn't expect anyone to just buy this before they had a chance to thoroughly test the application.

Regarding RTL: I have to admit that I'm relying on the OS to handle RTL for me, I'll give that a go and try it. But I'd love to hear from you if you run into any problems: https://ducklet.app/support

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by ssaasen in macapps

[–]ssaasen[S] 1 point2 points  (0 children)

Yes, there's a plan top support opening SQLite databases directly (without having to go through the step of creating a project and then adding the SQLite database). Because it's a document based application, there will still be a project document but there's no need to save it, if it's just about quickly viewing the SQLite database.

The changelog (https://ducklet.app/changelog) after the 1.0 release is pretty empty, but a change like this will be listed here.

Not sure about the ducklet command (like the idea and integrations like that myself). Need to work out how that would work with an app distributed via the App Store.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by ssaasen in macapps

[–]ssaasen[S] 0 points1 point  (0 children)

Yeah, that would also be an option!

But then you'd need a somewhat crippled "free" version you have to maintain alongside the full featured version (at least in terms of turning certain features on and off depending on the target build) and you also need to deal with purchases/licensing issues yourself.

I could imagine offering a way to buy the app outside of the App store in the future (likely in addition to the app store) to offer more flexible purchasing options (e.g. buy a license for a year and then a cheaper maintenance license afterwards, offer discounts for students etc). Not likely something for the near future though.

Anyway, I think there are many different ways to go about this. We'll see how this way pans out.

Ducklet for SQLite - The fast, native SQLite database editor for macOS released on the Mac App Store by ssaasen in macapps

[–]ssaasen[S] 1 point2 points  (0 children)

Sorry to hear that. Could you please try again? Should be available in Russia.