'No Stupid Questions' (NSQ) Internet & Technology Edition

[Velanna]

I'm really sorry if this is in the wrong place.

The gist of this whole thing: how do I split a string in a cell, and insert it into a new row keeping other information with it.

I'm trying to teach myself SQL and I'm currently working on a guided project with this dataset:

https://data.cityofnewyork.us/Environment/2018-Central-Park-Squirrel-Census-Squirrel-Data/vfnx-vebw/data_preview

I know it's really stupid but I'm stupid as well so I'm starting off with something light so I can learn. Anyway I'm trying to normalize the data. I'm working through 1NF and I'm trying to have it so there is only one fur color per cell in the Highlight Fur Color column. So basically I want to split the two colors in the highlight Fur color and create a new row with the same information except for the highlighted fur color. So basically instead of this:

Spoiler

id	date	age	primary	highlight
1	10172018	adult	gray	white
2	10102018	adult	cinnamon	grey,white
3	10122018	adult	cinnamon	white

I want this:

Spoiler

id	date	age	primary	highlight
1	10172018	adult	gray	white
2	101020118	adult	cinnamon	grey
2	10102018	adult	cinnamon	white
3	10122018	adult	cinnamon	white

I'm thinking of dropping the combo fur column entirely. I tried using cross apply but I'm using mysql which doesn't support that. So I *think* I need to use a function or a substring index or both. The closest I can find to helping me is this: https://stackoverflow.com/questions/17942508/sql-split-values-to-multiple-rows

I've narrowed it down to either the second part of the top solution (the 'if you cannot create a table') or the JSON solution.

The only problem I'm having is that every solution I come across has them writing a statement for each row, but the dataset I'm using has 3000+ rows which is why I think I need a function, but the JSON version looks easier however I don't know if it will work with the data I'm using. Can anyone dumb this info down for me so I can understand how do this?

 

[Samson Pumpkin Jr.]

Write down the exact times when it happens and then take a look in event viewer, might be a driver stumbling over something. Knowing what the blue screen said would also be helpful.

Thank you.

I also want to know what this very common and not intensive application is...

A messenger program, like skype or telegram

 

[Major Discord]

I am having a bit of an issue understanding the finer details of software licensing.

What I ultimately want to understand is the following:

1. Let's say you have developed a software for either your own personal use or for the internal use at your workplace. The software is not going to be sold in any way or form. You do, however, distribute the program to other people working with you (or at your workplace). When developing the software you have used freely available packages on the internet (e.g., github) and even copied and modified certain parts from the source code to fit your needs. You never cared about what licenses any of these packages had.
2. This software is used to facilitate the creation of something real, physical that you will be selling. Let's say for an example, it is a software that is used to simulate certain mechanical stresses in a 3D object. Your goal is to 3D print a specific part, which will be sold. In order to make sure the part works, you use this personal software to simulate the mechanical stresses. Basically you are using the software during the development of the part.
3. You finish the development, everything works and you do business by selling the 3D printed part. The software itself is never a product.

Question:
Do you care about the types of licenses that the packages/ code snippets in your program use?

1. Say, if you have an AGPL license there somewhere, or something else, can this lead to potential problems and you being sued?
2. If you use licenses like GPL or something else, does it mean that you need to publish the source code of your internal program?

Ideally I would like some court case study or some way to find a definite answer to these questions.

Thanks!

 

[⠠⠠⠅⠑⠋⠋⠁⠇⠎ ⠠⠠⠊⠎ ⠠⠠⠁ ⠠⠠⠋⠁⠛]

A messenger program, like skype or telegram

You're a Discord pedophile? I see why you didn't want to say.

Ideally I would like some court case study or some way to find a definite answer to these questions.

I don't think you'll find one as it doesn't sound like you (or your employer) are offering services, let alone network services, to the public. Just (already designed) products. I'm not aware of any copyleft license intended for software (as opposed to things like the Creative Commons license for furry porn) that places you under any obligation in regards physical products.

AGPL wise, the relevant paragraph is

Notwithstanding any other provision of this License, if you modify the Program, your modified version must prominently offer all users interacting with it remotely through a computer network (if your version supports such interaction) an opportunity to receive the Corresponding Source of your version by providing access to the Corresponding Source from a network server at no charge, through some standard or customary means of facilitating copying of software. This Corresponding Source shall include the Corresponding Source for any work covered by version 3 of the GNU General Public License that is incorporated pursuant to the following paragraph.

So, if you or your colleagues use AGPL software like OpenRadioss as part of your workflow, which also includes bits that you've written and bits of software from others under various other licenses, then that's clearly fine if it's just being used to create products. If you receive inquiries from customers via email or webform, and as part of responding to those inquiries you or your colleagues happen to use AGPL software that's only available internally as part of the response to the inquiry (maybe creating new products to spec) then that's also perfectly fine.

Where it would get into a lawyery zone would be if the AGPL software is being used directly as part of a network service. Let's say you are offering custom 3d printed dragon dildos to be used on fucking machines, and you allow customers ordering from you to specify their desired diameter, length, and maximum acceleration.

If they can punch their desired values into a form, and that is then automatically used to calculate what an appropriate structure would be including iterating various different forms and sizes of reinforcing within the dragon dildo using OpenRadioss to ensure they will not deform under the expected stress, and they then get sent to a results page showing how much their custom product will cost, that would get into the lawyer zone.

I know it's really stupid but I'm stupid as well so I'm starting off with something light so I can learn. Anyway I'm trying to normalize the data. I'm working through 1NF and I'm trying to have it so there is only one fur color per cell in the Highlight Fur Color column. So basically I want to split the two colors in the highlight Fur color and create a new row with the same information except for the highlighted fur color. So basically instead of this:

It's good to learn on something you're interested in.

For the example you give, I don't think you want to be duplicating the observation ID's and dates in a table that's focused on colors.

I would argue that 'Cinammon colored squirrels with gray & white bellies' are their own distinct colorway. A more 'normal' data structure could be two tables, one is the 'squirrel colorway' table with:

ColorwayID	Primary Coat Color	Secondary Coat Color
1	Gray	Gray
...	...	...
13	Cinammon	Cinammon
14	Cinammon	White
15	Chinammon	White + Gray

The other is the 'squirrel observation' table with:

ObservationID	Datetime	Age	ColorwayID
1	2020-03-04	Adult	1
2	2020-03-04	Adult	14
3	2020-03-04	Adult	15

Or, if you do have some need to be able to analyze how many squirrels have any 'gray' or 'white' or 'black' or 'cinammon' color in their coats anywhere, your colorway table could look like:

ColorwayID	Color type	Primary Coat Color
1	Primary	Gray
...		...
13	Primary	Cinammon
14	Primary	Cinammon
14	Secondary	White
15	Primary	Chinammon
15	Secondary	White
15	Secondary	Gray

More normal. Arguably more annoying to work with.

 

[herefortheactualthreads]

I wanna do some shitty streaming to pass the time and because I want to make it more complicated then necessary, I want to multi-stream. Anyone know how to get josh's chat thingy to work or can suggest an alternative to have chat on stream? Not that I am expecting any watchers but I would be neat to have.

https://github.com/jaw-sh/stream-nexus

Also got to figure out a way to get verified on rumble

if you want to multistream, you should check if your upload speed can handle that.

go to speedof.me and check how much your upload speed is and divide that through 8 because bits and bytes autism.

if you took the amount divided by 8, thats the megabytes you have and then instead of like 6MB you have 6000kb for the bitrate on OBS. ( for good quality on your streams you should check each bitrate recommendations on each platform you gonna stream. )

if you have enough upload speed for multiple platforms you divide the amount of bitrate by the amount of platforms, and then hope to god your OBS doesnt kill itself.

for multistreaming on OBS i recommend this rtmp tool, axelchat for all chats in one window and Botrix for alerts and goals for your chat. (you can also use the chat with it if you feel like it).

however since i learned i can't do multistreams i'll just stick to the free plan of restream.io which does all the above except for alerts for me. you can also try to use Streamelements instead of OBS if you want some handholding while going through the process of setting everything up.

 

[Wind Rammer]

-snip-

Thanks, i'll check out these tools. At first glance, axelchat seems to be what I want. Too bad I won't be able to stream on as many platforms as I expected given my upload speed but it just supposed to be for fun anyway so no big deal. I just want to stream my games when I feel like it and and a backup channel whenever I get banned for saying nigger. No need for alerts and goals, those are just annoying as a viewer and don't really want to grow an audience anyway.
Maybe there's another service like restream.io, get both and stream everywhere at once. I have prepared channels on Odysee, Trovo, Kick and Twitch. I wanted Rumble and Youtube but both need a verification and giving my phone number is too much to ask. Any other platform you recommend?

 

[herefortheactualthreads]

Thanks, i'll check out these tools. At first glance, axelchat seems to be what I want. Too bad I won't be able to stream on as many platforms as I expected given my upload speed but it just supposed to be for fun anyway so no big deal. I just want to stream my games when I feel like it and and a backup channel whenever I get banned for saying nigger. No need for alerts and goals, those are just annoying as a viewer and don't really want to grow an audience anyway.
Maybe there's another service like restream.io, get both and stream everywhere at once. I have prepared channels on Odysee, Trovo, Kick and Twitch. I wanted Rumble and Youtube but both need a verification and giving my phone number is too much to ask. Any other platform you recommend?

not sure about the phone verification on rumble but rumble needs 5 followers for me to stream there, which i dont have lol.
i also used DLive, Vaughn.Live and the Telegram streaming function after i made the group/broadcast.

however i currently yeeted restream.io back in and only use youtube and twitch. there isnt much of a point streaming on 8 platforms when obs keeps killing multiplayer games and streams due to low bandwith lololol, it was still fun while it lasted talking to randoms who joined my streams sometimes.

 

[Smaug's Smokey Hole 2]

there isnt much of a point streaming on 8 platforms when obs keeps killing multiplayer games and streams due to low bandwith lololol, it was still fun while it lasted talking to randoms who joined my streams sometimes.

Is there much of a point to stream to more channels than viewers?

 

[glow]

Say, if you have an AGPL license there somewhere, or something else, can this lead to potential problems and you being sued?

It's completely fine to use AGPL or GPL software in your process, and for commercial processes, but you must be prepared to open-source any code that links with GPL code and any code that interacts with AGPL code, either via linking or via a network. You also need to open-source your modifications and contribute these back (or try to do so). If you are comfortable with doing so, this is fine.

Where people get sued is where they don't do this. The other really big problem that can happen is a few years later when you're violating these licenses and thinking it's OK because it's just some stupid nerd shit anyway and you want to take on a large investment or sell the business and in due diligence they discover this situation and they make putting it right a condition to proceed. If you're really unlucky the OSS project also has a commercial business attached and now you're negotiating with private equity backed sharks from a position of weakness, and they will not be gentle.

 

[Rololowlo]

What is the best upscaler for results close to integer when integer isn't available? Most upscalers are intended to get closer to the output resolution, not the internal one.

For example if I'm running 1440p on a 4K monitor, the idea is to have a result mostly comparable to 1440p on a native 1440p monitor, untreated and unprocessed.

Playing around with Lossless Scaling, bilinear or nearest neighbor seem like good candidates to my clueless eyes, but I'm open to more technical answers.

 

[Old English Roast Beef]

If it's only 30gb, that could fit with using something like Syncthing (in send only mode for the folder) to synchronize it over to a family member/trusted friend's computer rather than 'the cloud' (a random creepy Indian's computer).

In addition to, not instead of backing it up to an external HDD.

Using SyncThing and other sync software is not safe for backups. It works if your drive fails completely, but if the problem is something else like data corruption or file deletion, those changes will get synchronized as well.

 

[⠠⠠⠅⠑⠋⠋⠁⠇⠎ ⠠⠠⠊⠎ ⠠⠠⠁ ⠠⠠⠋⠁⠛]

Using SyncThing and other sync software is not safe for backups. It works if your drive fails completely, but if the problem is something else like data corruption or file deletion, those changes will get synchronized as well.

Many backup solutions will write off older copies of files anyway.

SyncThing does have options for enabling file versioning retaining 2 or more copies of overwritten/deleted files (in case your primary media is miraculously hit by cosmic rays that randomly damage data but don't affect the checksum) and a simple recycle bin where any 'deletes' received don't actually get deleted, just put into a hidden folder.

It's a much more likely to actually be implemented solution for 'keeping a second copy with a friend' than using a second external HDD, and much safer than relying on the clown. But you're right, I should have called out those file versioning options before. Unless you're doing something insane like syncing large video production projects, they don't add much to the disk usage on a 'target' machine, and they're handy to have if something is inadvertently deleted.

 

[herefortheactualthreads]

Is there much of a point to stream to more channels than viewers?

it depends, for me personally i just want to reach out for more people, and get my name out there. but only streaming on one platform makes it harder to grow the channel.

 

[A Series Of Tubes]

I have a folder dating from an old Win7 install in my documents simply called "C" there are two recycling bins inside of it...one contains 84 files, the other contains 0. It takes up 258 bytes. What the hell is this shit?

 

[herefortheactualthreads]

I have a folder dating from an old Win7 install in my documents simply called "C" there are two recycling bins inside of it...one contains 84 files, the other contains 0. It takes up 258 bytes. What the hell is this shit?

probably just trash.

 

[std::string]

Anyway I'm trying to normalize the data. I'm working through 1NF and I'm trying to have it so there is only one fur color per cell in the Highlight Fur Color column. So basically I want to split the two colors in the highlight Fur color and create a new row with the same information except for the highlighted fur color.

You shouldn't, it's time data.

So for example I see a squirrel at midnight. I observe it as primary: cinnamon, highlight: white, grey. You split that into two rows and suddenly I've seen two squirrels at midnight, one cinnamon and white and the other cinnamon and grey.

 

[A Series Of Tubes]

probably just trash.

I made a throwaway on R*dd*t awhile back to try and figure out what it was and some retard was saying it was tied to System Volume Information which sounded like a crock of shit.

 

[Post Reply]

I have a folder dating from an old Win7 install in my documents simply called "C" there are two recycling bins inside of it...one contains 84 files, the other contains 0. It takes up 258 bytes. What the hell is this shit?

The real problem here is that you haven't wiped your drive and done a fresh install since Win7 was around.

 

[Rololowlo]

Probably a niche question: will disconnecting the internal antenna be enough to make the device unable to connect to wifi? If not then what will?

I used to have a defective tablet where the wifi wasn't working and damn, "just don't use Internet lel" doesn't even come close to the peace of mind and mental silence of being technically, mechanically unable to go online even if you wanted to. Textbook if-you-know-you-know. I binged on ebooks and retro games with a focus I hadn't felt in years.

I tried Linux handhelds from Anbernic, and even 351droid, but it always ended up too restrictive vs the Swiss army knife features and convenience of a full touch-enabled Android.

 

[herefortheactualthreads]

I made a throwaway on R*dd*t awhile back to try and figure out what it was and some retard was saying it was tied to System Volume Information which sounded like a crock of shit.

it seems like a partition which probably doesnt have much of a value if you installed new OS'ses over it.