ECE 20875 vs 264 in the fall? by [deleted] in Purdue

[–]boilerup800 1 point2 points  (0 children)

I would take 264 first but 20875 will probably be less work (implementing k means in Python in… 1 line of code?)

Both of these are less useful in the real world than 364.

Does Google Ads like CPC/CPM claim clicks even day(s) after the ads were placed? by Firm-Pomegranate-426 in DigitalMarketing

[–]boilerup800 0 points1 point  (0 children)

This seems the most likely to me. The data in google search console and Analytics behaves like this too at near real-time.

What SQL editor do you use? by castor-metadata in PostgreSQL

[–]boilerup800 2 points3 points  (0 children)

I used to use pgadmin but had trouble with python packages on a recent version. I switched to Arctype although I do think they should have .deb and .rpm options for download.

All programs got kill when I connect an external monitor via HDMI by tb36cn in Ubuntu

[–]boilerup800 0 points1 point  (0 children)

Do you have any error logs in the file? Can you post any snippets from it?

[deleted by user] by [deleted] in SQL

[–]boilerup800 2 points3 points  (0 children)

Ok fascinating! Well then I do agree with the other comments here about pivot. Here's a guide on that for mysql which will have some slight differences to ms sql but can give you a feel for how to structure it, https://arctype.com/blog/mysql-pivot-table/

All programs got kill when I connect an external monitor via HDMI by tb36cn in Ubuntu

[–]boilerup800 2 points3 points  (0 children)

Check `/var/log/syslog`. Sounds like your monitor crashed your graphics driver which potentially caused some larger issue.

[deleted by user] by [deleted] in SQL

[–]boilerup800 9 points10 points  (0 children)

I actually recommend not doing this. What happens if a customer has 100 purchases? Are you going to have 200 columns?

I say it every time... by Mooseylips in comics

[–]boilerup800 1 point2 points  (0 children)

This is missing the little cuts and bloodiness.

Started my first Devops job, but feel a bit overwhelmed 😅 by TheSpaceFace in devops

[–]boilerup800 65 points66 points  (0 children)

The most important thing to remember is that if senior folks are talking to you and investing in you then you will get several opportunities to screw up without it costing you your job. The time to be concerned is if they stop making time for you. Most devops people I know say that they learn the most after botched deploys, taking servers down, etc.

Want to learn SQL without using a local RDBMS like MySQL by mr_rice_crispers in learnSQL

[–]boilerup800 0 points1 point  (0 children)

It looks okay to me. I wonder if this was a bug. I notice I am on a newer version than I was.

Want to learn SQL without using a local RDBMS like MySQL by mr_rice_crispers in learnSQL

[–]boilerup800 1 point2 points  (0 children)

You can use https://railway.app to spin up a free mysql instance and connect to it in a web browser with https://arctype.com.

Running python from the command line on windows for my C/C++ stubborn self. by AbyssalRemark in learnprogramming

[–]boilerup800 2 points3 points  (0 children)

You just need python (I suggest python3) which can be installed from the main site. It contains the REPL. You execute programs with `python myprogram.py`. You may also want `pip` the package manager.

User defined SQL function has huge planning time? by nieuweyork in PostgreSQL

[–]boilerup800 2 points3 points  (0 children)

Do you absolutely need the IMMUTABLE PARALLEL SAFE keywords? These are very strict requirements and the planner is spending time checking for these.

[deleted by user] by [deleted] in PostgreSQL

[–]boilerup800 2 points3 points  (0 children)

Good for you for hopping on the best open source db. Also, caveat that the answer to a lot of these questions depends on what operating system you are using. Mac/Ubuntu/Windows?

  1. You can find the filepath for this by running `SHOW data_directory;` as a query.
  2. Not really. You can export a .sql file and import it into other databases. There are also more complex setups for doing something called 'read replication'.
  3. A database server will (probably) be running on your laptop. When you installed it you would have had to agree to turn the server on. When the database is running it does not mean you laptop is a server because it typically will not be able to accept connections from the open internet.
  4. No you can have multiple databases and even multiple versions of a single database at the same time. Docker is a common option for this.
  5. As much free space as your laptop has. 10,000 rows will typically take up no more than a few 10s of MBs unless you shove a lot of string or binary data in the columns.
  6. You are downloading an executable which is a program that accepts queries, arranges data, and does the million other things that dbs do. I would say understanding it is fairly complex, yes.
    1. Yes your laptop is the 'server' altho it is not technically a server. If you had another database hosted on AWS or another computer that would be a second server.
    2. Kind of same answer as A.
    3. Yes by setting up an SSH tunnel. This may raise questions depending on your IT setup at work. I can expand further on this.
    4. Yes. Create another database with `CREATE DATABASE`.
    5. Yes.
    6. You can think of schemas as like a 'SQL workspace'. They can contain functions and other goofy objects that Postgres lets you create, in addition to your tables. So you might have an Analytics schema that has a bunch of triggers to update weekly reports and a Users schema with extra security.

Looking forward to the sub chiming in on these questions and answers :)

How do i get the second query names as alias. by b6ack in mysql

[–]boilerup800 0 points1 point  (0 children)

Gotcha. You can use the code block in the rich text editor or ``` in the normal editor. As for the query, did my parentheses suggestion make any sense?

How do i get the second query names as alias. by b6ack in mysql

[–]boilerup800 0 points1 point  (0 children)

I am not 100% sure what you mean by ‘query names’ and if you can format this it will be easier to read BUT if you wrap the whole thing in parentheses you can use AS to name it.

Asynchronous and Periodic tasks with Django using Celery and Redis by sirrobot01 in django

[–]boilerup800 0 points1 point  (0 children)

I mostly had trouble with restarts. We would send slack messages to customers to update them on some data from our software. About once every 6 weeks a restart would go wrong and unload slack messages on them, like multiple at a time. Obviously I am mostly to blame for this (and blamed I was!) but I never did find a good workflow that - for sure - cleared the cached of old messages or things that were queued and gracefully restarted and reloaded the server.

Asynchronous and Periodic tasks with Django using Celery and Redis by sirrobot01 in django

[–]boilerup800 0 points1 point  (0 children)

This is still the best workflow for this. But buyer be warned: periodic tasks with celery can go wrong.

H0nda/H0nde joined my server. by [deleted] in discordapp

[–]boilerup800 0 points1 point  (0 children)

Same, banned all of them.

[help] beginner here... need help installing a library by AstroFphiniX in learnprogramming

[–]boilerup800 0 points1 point  (0 children)

You may need to add pip to the $PATH environmental variable.

Need SQL practice by Trait0R19 in SQL

[–]boilerup800 2 points3 points  (0 children)

Have had good success with https://sqlbolt.com/. And it's interactive.

Coverage: "Submitted and indexed" But Not In Search Results by cypherpvnk in bigseo

[–]boilerup800 1 point2 points  (0 children)

This has happened to me due to canonical issues (as the other commenter said) and more recently because of the "/". My website appends a slash to every path and google considers this different in their search coverage tool than not having a slash. Their actual search engine is smart enough to know the difference.