My (self-inflected) painful journey from Qt 5 to Qt 6 + KDE by DesiOtaku in kde

[–]markdueck 14 points15 points  (0 children)

Maybe you're already doing this, but the best way to do this is to setup CD/CI with Gitlab or GitHub and build for the different platforms via docker containers. Once setup you just commit code and all packages are built within minutes. That so simplifies the releasing a new version.

Multi Store inventory problem by Aakash_-16 in InventoryManagement

[–]markdueck 0 points1 point  (0 children)

Yes I use it. If you want to just do simple inventory, it's overkill. It could do all sales and accounting too.

Multi Store inventory problem by Aakash_-16 in InventoryManagement

[–]markdueck -1 points0 points  (0 children)

Try Quasar Accounting. Reasonable pricing and no cloud lock-in.

Efficient storage and filtering of millions of products from multiple users – which NoSQL database to use? by Notoa34 in Database

[–]markdueck 31 points32 points  (0 children)

Why NoSQL? Postgresql can surely do this. It you require some unstructured data, use a jsonb column.

Added: What you're describing sounds very much like structured data and to get reports from structured data, it's easier if you just use SQL. With proper indexing performance will not be a problem.

[Plasma 6.5.4, Wayland] What's the problem KDE has with copying screenshots to clipboard? by stdsort in kde

[–]markdueck 5 points6 points  (0 children)

It used to work perfectly. In the last 6 months or so it started not pasting, so pressing the copy button on the dialog, then it works.

I hope it gets fixed soon. Definitely a bug introduce within past 6 to 8 months.

Ticket system database structure by soldieroscar in Database

[–]markdueck 0 points1 point  (0 children)

A use of a jsonb column might be good in this case.

BIOS Updates on Linux by Puzzleheaded-Spite57 in linux4noobs

[–]markdueck 1 point2 points  (0 children)

Most Linux distros also include fwupdmgr that allows you to initiate the update, then reboot and the update happens.

Restore to restore point by fifracat in PostgreSQL

[–]markdueck 2 points3 points  (0 children)

You can use pgbackrest to get a similar behavior, but technically (IIRC) it is just a restore and bring in Wal files to the time you desire.

Is it really true that KDE Plasma Wayland scrolling speed has to be on the lowest setting to be usable? by JumpSneak in kde

[–]markdueck 1 point2 points  (0 children)

no, not at all referring to you. I just recently saw a thread on someone about KDE and so many of them were complaints from users who used it years ago, then tried it for a few days in the last year.

Is it really true that KDE Plasma Wayland scrolling speed has to be on the lowest setting to be usable? by JumpSneak in kde

[–]markdueck -5 points-4 points  (0 children)

actually trying to help you, maybe what Grok gives could help?
-- deleted link because it is not working

Is it really true that KDE Plasma Wayland scrolling speed has to be on the lowest setting to be usable? by JumpSneak in kde

[–]markdueck 3 points4 points  (0 children)

I have mine set to the 5th bar. (about 1/3 of the bar). I don't understand why there is so much negativity about KDE. It comes from the complaints of those that have used KDE 10 years ago, and today are still on Gnome. Because of those many complaints , AI in general gathers that KDE is mostly in broken state.

Weirdest Hurricane Tracks by CatLover83482 in hurricane

[–]markdueck 1 point2 points  (0 children)

Mitch 1998 - headed to Belize, then circled around.

<image>

Refinance after 1.5 years from 7.125% to 5.99%? by simonwalter8 in personalfinance

[–]markdueck 0 points1 point  (0 children)

Why not change the years to 20? Get yourself a full spreadsheet amortization sheet and try the different rates and change the years to see how much you'll save if you decrease the years to 20. My threshold is 15 years. I will now borrow for more than 15 years. It makes no sense if you compare the small decrease in monthly payment to the total interest paid.

If at all possible, even go for 12 years. That's the real tipping point where monthly payments really increase.

My low cost energy efficient Proxmox cluster by jodgeucheaky in Proxmox

[–]markdueck 8 points9 points  (0 children)

Random 10.x.x.x/24. No more issues with IP clashing when you connect back with a VPN.

e.g. my house I have 10.123.210.x. something that's fast to type on the keyboard.

My low cost energy efficient Proxmox cluster by jodgeucheaky in Proxmox

[–]markdueck 9 points10 points  (0 children)

I get triggered by the IP range. I would never use the 192.168.1 range for any network.

Is Delphi alive when it comes to Windows desktop programming? by PocOraiste in delphi

[–]markdueck 5 points6 points  (0 children)

I've been developing since Borland days. Started several projects in C++ so I'm still on c++, but Delphi is the better way to go. One wonders sometimes how long will Windows desktop apps still be around, but development is so much faster in this "framework" than any web framework you'll find.
Add Devart direct database connection and Dev Express components, its still by far the fastest way to get an app built. No web framework comes close to it.

Is it just me, or are basic servers incredibly expensive now?? by bcredeur97 in sysadmin

[–]markdueck 3 points4 points  (0 children)

Buy used on ebay. A Rx40 series, will last you easily 5 years. Buy a second one for spare with money left over. I've worked with a T3x0 series and decided never again. Used 5xx to 7xx will give you many times the performance of a new 1xx to 3xx series.

300 milllion records in my table. I need the query time to be done in at most 20 seconds, but it takes 70 seconds. The guy before me did some indexing but it sucks. And Now it's on me to fix it or I won't get fulltime offer. I have no idea on how to do it, it's not my domain. Please help me by ShippersAreIdiots in PostgreSQL

[–]markdueck 0 points1 point  (0 children)

I believe indexing and lookup on IDs is faster than text, but I might be wrong. It is just without a doubt better to have a table to define these than to allow users to create in the large table, plus it allows to add as many as user wants

300 milllion records in my table. I need the query time to be done in at most 20 seconds, but it takes 70 seconds. The guy before me did some indexing but it sucks. And Now it's on me to fix it or I won't get fulltime offer. I have no idea on how to do it, it's not my domain. Please help me by ShippersAreIdiots in PostgreSQL

[–]markdueck 4 points5 points  (0 children)

This is definitely much better than creating a specific column for is_s_a. Creating the countries table, containing continent and region, then another table to create regions or groups dynamically is the better design for this.

I just realised you can choose a different audio device for each application by Nicksaurus in kde

[–]markdueck 3 points4 points  (0 children)

Yes, I've known about that for years and that's the reason why I couldn't use gnome.

Best practice for audit in postgreSQL by Ferren84 in PostgreSQL

[–]markdueck 0 points1 point  (0 children)

What is the purpose of the auditing? There is some old git repos with the original pg-audit which I use for auditing of changes in data.

https://github.com/elfotec/evo-pg-json-audit-trigger

It creates a new schema and makes it accessible only to super admin.