The Portable Freeware Collection Forums

Any news?

A quick thing: the entry changelog (i) button seems to have disappeared with the latest UI tweaks.

Have you tried one of the tools of https://framasoft.org/en/ ?

It took a while because I wanted to make sure I moved posts over correctly (there was some overlap), but this is now a separate thread for GUI vs. CLI analysis. Thanks! I changed the title. I hope you don't mind. It would just come down to personal preference for inclusion. While this is inevitable...

Worth noting that this doesn't work on .NET Core. While .NET Core itself is cross-platform, all major UI frameworks for it are a part of "Windows Desktop Pack" which only works on Windows: https://devblogs.microsoft.com/dotnet/net-core-3-and-support-for-windows-desktop-applications/ True, but I was...

Andrew Lee wrote: ↑

Fri Sep 18, 2020 8:55 pm

Thanks for all the suggestions. I will do some tests and try to figure out which is the best path to go.

My pleasure. Good luck and thanks for the openness and help.

Quick mockup for a possibility:

I wrote this before I saw your post: I am going to put some ideas out there and we can sieve them: - put the limit in UI: a radio button instead of a checkbox. - two fields for each: one a reference and one for actual data. - special text like app=xx in the fields - put the referenced values (of the...

I am also mulling over exposing the entire left join to the front end (which will have to do something about it). I don't get that part. The decision to make now is which hack job is least painful and more sustainable going forward. :roll: I think maybe a checkbox per independent/heritable (the thr...

I think these are called virtual tables. https://www.quora.com/What-is-a-virtual-table-in-SQL -------------------- However, you can create a unique clustered index on the view – referred to as an indexed view – to persist the data on disk. This index can then be used for reads, reducing the amount o...

Thanks a lot!

I think this solution is too heavy and not scalable. When doing search results or category listings, a whole bunch of rows are retrieved, not just one. Imagine doing the above, then tag on a couple of additional criteria to retrieve a list of matching entries. Then scale this up to multiple searche...

"Runs on" I can see some real advantages with that. For example, we do have those webpage-based applications (https://www.portablefreeware.com/forums/viewtopic.php?p=97672#p97672) that are OS-independent, and I think are going to keep growing. If so, "Runs on" might be the best descriptor. Then aga...

entry_id entry_site entry_size entry_license entry_os parent_id 123 site1 2500 foss 7,8,10 123 124 NULL 100 NULL NULL 123 125 NULL NULL free 10 123 126 site4 500 lite vista NULL 127 mistake 450 free xp 123 WITH tableSize AS ( SELECT a.entry_id, b.entry_size FROM mytable a LEFT JOIN mytable b ON a.p...

Interesting read. From the quote, I thought the IA is using CF for uptime and availability (given the server issues IA seems to be having recently). But after reading it is closer to the other way around.