Search found 365 matches

by vevy
Tue Sep 22, 2020 2:27 am
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

👍

Any news?
by vevy
Mon Sep 21, 2020 5:24 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

A quick thing: the entry changelog (i) button seems to have disappeared with the latest UI tweaks.
by vevy
Mon Sep 21, 2020 4:29 pm
Forum: Resources & Links
Topic: Documentation tools and services
Replies: 1
Views: 171

Re: Documentation tools and services

Have you tried one of the tools of https://framasoft.org/en/ ?
by vevy
Mon Sep 21, 2020 4:25 pm
Forum: Suggestions/Discussions
Topic: Forum suggestions
Replies: 66
Views: 27541

Re: Forum suggestions

Title 1 Title 2
Much
cleaner
looking.
Thanks!
by vevy
Mon Sep 21, 2020 4:18 pm
Forum: CLI Discussions
Topic: GUI apps in the CLI Database?
Replies: 19
Views: 125

GUI apps in the CLI Database?

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...
by vevy
Mon Sep 21, 2020 4:00 pm
Forum: Suggestions/Discussions
Topic: Rename System requirements to "OS support" (Edit: or "Supported OS")
Replies: 15
Views: 1166

Re: Rename System requirements to "OS support" (Edit: or "Supported OS")

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...
by vevy
Fri Sep 18, 2020 8:57 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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:
radio.png
by vevy
Fri Sep 18, 2020 8:42 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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...
by vevy
Fri Sep 18, 2020 8:27 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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...
by vevy
Fri Sep 18, 2020 8:10 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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...
by vevy
Fri Sep 18, 2020 8:05 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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...
by vevy
Fri Sep 18, 2020 7:59 pm
Forum: Suggestions/Discussions
Topic: Rename System requirements to "OS support" (Edit: or "Supported OS")
Replies: 15
Views: 1166

Re: Rename System requirements to "OS support" (Edit: or "Supported OS")

"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...
by vevy
Fri Sep 18, 2020 4:20 pm
Forum: CLI Discussions
Topic: CLI Database Discussions
Replies: 266
Views: 110418

Re: CLI Database Discussions

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...
by vevy
Fri Sep 18, 2020 11:08 am
Forum: Resources & Links
Topic: My Tips for the Wayback Machine
Replies: 7
Views: 10221

Re: My Tips for the Wayback Machine

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.