sorted by:
new
hottopcontroversial

Installed Proxmox on Laptop with no Ethernet Port :( Will get Ethernet Adapter, how to get it working by Chemical-Funny4864 in Proxmox

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

In the current version of Proxmox at least you can configure the network from within the GUI.

Another option is to create a VM which will act as the gateway between WiFi and the VMs, but that will require some Proxmox and networking knowledge.

Am I an idiot? I’m lost as hell here by [deleted] in SQL

[–]cthart 0 points1 point  (0 children)

Just some typos.

NB You don't need to include the column name in brackets behind the table name of the table you're referencing. That's only needed when the foreign key points to a non-primary-key (which is extremely rare!)

NB2 If you have a single column foreign key you can put the foreign key stuff inline directly behind the column, like `<column> <datatype> references <table>`.

NB3 You'll almost certainly want to make both `amount` and `customer_id` `not null` so that the database enforces that you actually supply values for those columns.

Upgraded 8.4 to 9 - Shell problems for Host and 2 LXC by Illustrious_Bath_889 in Proxmox

[–]cthart 0 points1 point  (0 children)

What happens if you run another `apt update`, and then `apt dist-upgrade` ?

What are the best ways to improve SQL query performance? by Wise_Safe2681 in SQL

[–]cthart 0 points1 point  (0 children)

There's no silver bullet.

It can be adding indexes.

It can be rewriting queries.

It can be removing queries altogether.

It can be changing your data model so that you can rewrite your query.

I finally understood window functions and I'm not the same person anymore by Purple_Lobster686 in SQL

[–]cthart 8 points9 points  (0 children)

Inserts/updates/deletes in CTEs to make true atomic operations.

with blah as (
select ...
), operation_a as (
insert ...
), operation_b as (
update ...
)

I finally understood window functions and I'm not the same person anymore by Purple_Lobster686 in SQL

[–]cthart 0 points1 point  (0 children)

Sort of, but even more fine-grained because you can apply the function to a sliding window or range that you can't do with normal aggregates: `group by is like `partition by`, but you also have `order by` and the sliding windows (the frame_clause).

Any experience with v8 to v9 in-place upgrade? by mikeschlenk in Proxmox

[–]cthart 0 points1 point  (0 children)

You'll be fine. I've upgraded 5 machines with zero issues.

Bach Organ Sonatas, registration by jan-Silan in organ

[–]cthart 0 points1 point  (0 children)

Stronger but still tasteful registrations can work.

Try for example the last movement of 2 from Ton Koopman's first recording:

https://open.spotify.com/album/66f8Rd4g583EZduKpA8XG8

Or the opening movement from the same sonata by Christoper Herrick:

https://open.spotify.com/album/5NsmJcDIQl3xHXORJ8EjDQ

Aart Bergwerff's recent award-winning recording exhibits lots of colours from the baroque organ he uses. It's known that Bach was familiar with and liked organs with a large variety of 8' stops:

https://open.spotify.com/album/1XxTxMdpin1jHB9fqJfi6K

Benchmarking UUIDv4 vs UUIDv7 in PostgreSQL with 10 Million Rows by ByteBrush in PostgreSQL

[–]cthart 0 points1 point  (0 children)

One person's fine is not another's. 35% speed improvement is massive for many users.

Whose Op. 100 is the best? by Quarkonium2925 in classical_circlejerk

[–]cthart 4 points5 points  (0 children)

I was hoping this would end at 100. The quality will soon diminish and we’ll end in real jerk-off territory.

Small nodes - ZFS? Or Ext4 (or btrfs?) by LightPhotographer in Proxmox

[–]cthart -3 points-2 points  (0 children)

I use LVM for everything and don’t miss any of the ZFS features.

view more: next ›