#sql

[exuberantocean]

...I'm having nesting flashbacks.

* (Oh, these parentheses I keep opening?

* (I'm collecting them.

* (Right now, I'm 1,762 parentheses deep.

* (Oh, my precious parentheses... (I don't ever want to close them!

[megmahoneyart]

Like I said, I don't have the bandwidth to do a daily art challenge this October, but that I'd do /some/ mxtxtober. And I HAD to do prompt 4: Wine Bottle 👀

[futurebird]

Do not help them to build any more of this machine.

If you work with a database and are asked to alter the table structure to comply in advance for citizenship or gender categorizations it's really important to NOT do it.

"The governor is concerned about all this stuff they want us to update our record keeping so we store both gender AND biological sex."

"We need fields to store the country of origin of people's parents."

If you don't have the power to rebuff this yourself, ask for help. At minimum ask for help online anonymously.

Depending on your job you probably have in the past made compromises. Maybe to keep your job. Maybe to survive. This is a bright line. If you are asked to be the one to update the table don't let it be your fingers typing those changes.

If you can't just say "No I won't do that." Stall, run away, feign incompetence. Just don't let it happen.

I suspect this might be where the rubber hits the road first for us around here.

Nothing has changed. You do not have to do it. It is not even ordained.

I know someone who rebuffed such a request. Boss was apologetic "it's what the higher ups want, oh *I* think it's a lot of nonsense, but I don't want us to be out of step ... blah blah"

It was proposed to them in sheepish way. They said it would be a lot of work, not add anything of value, and most important they would not do it. It didn't come up again.

Fascism can be the work of zealots, but there are also many sheepish middle management helping hands who "don't even believe in this really"

There is a lively discussion of this on mastodon. (Mastodon is a very active social network where many people who left twitter have gone over the past few years to escape many problems of big centralized socail media. I like it a lot.) Posting a response to this post over there could be a way to get lots of help and ideas from tech people all over the world with similar values. If you do need help. Please say something.

Also, if you respond to this post I can pass what you say along if that would help too. People will respond and give you ideas to NOT do this should you be asked.

[coffee-dad-studies]

Good morning. ☕ Last night, I took and passed my Database Management Applications exam, which was the last exam in my degree program. Here's a pic of some of my notes (which I intended to post the other night while I was actually studying).

I have until April 30 to complete my capstone project if I'm going to finish by the end of the term. (I do qualify for a one-month extension, though. I went ahead and requested it just in case I need a few extra days.)

Lots of research and writing will be happening over the next week. 📚

[lithiumdoll]

Enough of the gif/jif discourse

[jbcchan]

[onlytiktoks]

[akvamarinka-art]

Очень зацепила эта фраза в новелле

[systemdeez]

This faggot just got a B in their SQL class :3

[nerdymemes]

[nixcraft]

Wait what... ? this is dangerous knowledge.

[lunacoding]

SQL Interactive Websites

Hi! I wanted to share some websites that have helped me with bettering my SQL skills and are interactive, as in you can learn as you practice SQL on the website through an educational or fun way! 

SQL Bolt

This website is one of the best for beginners to SQL as it helps with explaining the different SQL statements as well as giving brief interactive exercises for each explanation/topic. Additionally, it offers help on more intermediate topics as well such as subqueries. However, this site doesn’t have many resources on more advanced SQL topics, so it may not be best if you’re more intermediate in SQL, but could be good for a basics refresher.

SQL Zoo

This website is another one which is good for beginners to SQL as similarly to SQL Bolt, it primarily explains different SQL statements and queries. There are brief interactive exercises as well as quizzes on various SQL topics. Additionally, there are assessments for more advanced users of SQL to test their knowledge which consist of 15 questions for different databases, including dressmaker, musicians, help desk, and so forth.

Select Star SQL

This website is an interactive SQL exercise where you learn as you go while interacting with a database of death row patients. The difficulty of queries slowly increases as you go through the exercise. I find this website helpful as it threw me into SQL and I prefer the learning while doing method, especially with real-world data. This could potentially be triggering if you don’t want to read the details of people being on death row.

SQL Murder Mystery

This website is an interactive SQL exercise where you try to figure out who committed a murder using SQL. This website is good for both beginners and more intermediate SQL learners. It offers a walkthrough for people who are completely new to SQL. Alternatively, the website gives schema details to those experienced with SQL and want to figure it out on their own.

SQL Police Department

This website is similar to SQL Murder Mystery where you try to figure out police cases through learning SQL. It has prompts where you then use SQL to try to figure out the information the police need. The site also has a guide on SQL and gives basic summaries on different queries. I found this site fun to use and it has a cool interface. However, one con of this site is you can only do a certain amount of SQL queries before it asks you to pay for the longer version of the site.

Practice SQL

This website has been my personal favorite as the interface is clean and easy to understand. The website gives you prompts to use SQL to select from two different databases, the first of which is based on doctors and patients in different provinces while the the second is based on products and their orders as well as employees who work at the company. For both of these databases, there’s a series of prompts/questions from easy to intermediate to advanced SQL. Additionally, there’s learning resources which helps explain different queries and functions of SQL as well, if you’re confused or need help!

I hope you guys find these websites helpful!!

[welele]

Viendo las webs gubernamentales y la de tráfico que tenemos, esa inyección SQL seguro que colaría.

[imall4frogs]

The “genius” of Elon Musk becomes more suspect with each passing day. Hypothetical question: If the source is too stupid to know that his information is wrong, would he be still be spreading disinformation?

[crackaddict55]

🤩Are you a CS Student !?!???? 🥳🤩😎CHECK OUT THESE-

No. No I’m not. I study at home.