Categories
Mastering Development

MySQL 8.0 query to compute recursively size at each node in the hierarchy based on the contents downstream

This is in MySQL 8.0. How do I use a recursive query to calculate bottom-up the size at each category node (type = 1). create table hierarchy ( name varchar(100), location varchar(100), type int, size int, parent_name varchar(100), parent_location varchar(100) ) engine=InnoDB default charset=UTF8MB4; truncate hierarchy; insert into hierarchy values (‘music’, ‘/’, 1, 0, NULL, […]

Categories
Mastering Development System & Network

Can I link domain accounts to Microsoft accounts?

I have a Windows Server Essentials 2016 server at home with a bunch of shared resources (photos, music, etc.). My kids all have Microsoft Account logins (because Family Safety only works with Microsoft Account logins). I’d like to share the resources with my kids, but I don’t want to migrate the logins to domain accounts […]

Categories
Linux Mastering Development Ubuntu

How do I programatically add/remove items from Nautilus bookmarks?

I want to remove Documents, Music, Pictures, Videos and add cloud to my Nautilus bookmarks as part of an user setup script. How do I edit the bookmarks via the CLI?

Categories
Linux Mastering Development Ubuntu

Need help to organize my hard drives as new Linux user

The goal is to keep temporary data off SSD in order to increase its life expectancy and have our games and Linux OS running fast and efficient. 120 GB SSD (m.2) should hold Linux OS with all OS applications 500 GB SSD to hold all video games 4TB (HDD) hold movie, music, temporary files, and […]

Categories
Artificial Intelligence (AI) Development

Neural network to extract correlating columns from csv

i want to use a neural network to find correlating columns in a csv file and give them as a output. The input csv file has multiple columns with 0 and 1 (so like booleans) in it. The file got the Assignment from people to interests in it. Example csv input: UserID history math physics […]

Categories
Development

get first row fo each group SQL

I have data like below. I would like to get the top choice for each gender from the following data subjectID <- c(“1”, “2”, “1”, “0”, “1”, “0”, “0”, “1”, “0”, “2”, “0”, “0”, “2”, “2”,”2″,”1″,”2″,”1″,”0″,”2″) gender <- c(“M”, “M”, “F”, “M”, “M”, “F”, “M”, “M”, “M”, “F”, “M”, “F”, “M”, “M”, “F”,”M”, “F”, “M”, […]

Categories
CMS Development Wordpress

wp_query not showing posts when user is logged in (non admin)

I created a related post function that I am calling in a sidebar: function get_all_related_posts(){ global $post; $postid = $post->ID; $tag_ids = wp_get_post_tags( $postid, array( ‘fields’ => ‘ids’ ) ); $args = array( ‘post_type’ => ‘any’, ‘tag__in’ => $tag_ids, ‘post__not_in’ => array($postid), ‘orderby’ => ‘date’, ‘order’ => ‘DESC’, ‘posts_per_page’ => 5, ); $the_query = new […]

Categories
Artificial Intelligence (AI) Development

Why is my loss (binary cross entropy) converging on ~0.6? (Task: Natural Language Inference)

Hi everyone, I’m trying to debug my neural network (BERT fine-tuning) trained for natural language inference with binary classification of either entailment or contradiction. I’ve trained it for 80 epochs and its converging on ~0.68. Why isn’t it getting any lower? Thanks in advance! Neural Network Architecture: Training details: Loss function: Binary cross entropy Batch […]

Categories
Development Linux Ubuntu

Lubuntu, even Ubuntu Studio… Even after re-instalation, they won’t boot!

Specs: GPU: ATI 1950XT PCI-E graphics card CPU: Intel Quad core 2, 64bit, 2.666Ghz, 1333mhz FSB Mobo: Asus p5kpl/1600 https://www.asus.com/Motherboards/P5KPL1600/specifications/ – 8 GB memory installed, but only 4 GB working – 4 SATA-II ports /dev/sda SSD SATA-III 250 GB /dev/sdb SSD SATA-III 500 GB /dev/sdc HDD SATA-II 750 GB All running from Lubuntu ‘live’ version […]

Categories
Development

Survey User Form count vba

I have a survey and I want to evaluate the results. There are 10 topics Football, Music, Instagram, Snapchat, Food, Love, Clouds, Travel, Discover, Fashion, They can be rated by 1. Good 2. Okay 3. Boring 4. Don’t care 5. Not interested I have created option buttons and I want that the result will be […]