#Database Engineer

[courseswebs]

Meta Courses 2023💙💙⬇️⬇️

*Meta Back-End Developer Professional Certificate

https://imp.i384100.net/P0XVBj

*Meta Database Engineer Professional Certificate

https://imp.i384100.net/5b6ZKb

*Meta Android Developer Professional Certificate

https://imp.i384100.net/x9W5Oy

*Meta iOS Developer Professional Certificate

https://imp.i384100.net/9WRz2E

*Meta Social Media Marketing Professional Certificate

https://imp.i384100.net/oevLnm

*Meta Marketing Analytics Professional Certificate

https://imp.i384100.net/a1qAPY

[solradguy]

Please god is there like a sol radguy GG masterpost for Metal Gear Solid I can't keep going to the Fandom wiki for information I'm going to throw up like surely someone's put a bunch of links to the comic scans and fan translations and stuff all together in one place, right?

Right??

[nobodysuspectsthebutterfly]

We know our man GRRM is fond of Beauty and the Beast, but i wonder if he was influenced for Sandor as well by Phantom of the Opera (another Batb story!). There's a Phantom adaptation which has the Phantom be named "Sandor", and he's not born disfigured, his face is burnt in a fire...And his dead wife has red hair. The film's from 1983 made for tv, obscure. maybe it's a coincidence but..

I checked GRRM's writings and interviews -- using zionius's So Spake Martin Extended search engine, which has everything -- and I'm afraid I can't find any time GRRM has ever even mentioned the Phantom of the Opera. I know sansan Phans have brought up the connection before, but the fact that, yes, POTO is also a beauty and the beast story may just be the simple reason for those shared tropes, sorry. And GRRM has said that Sandor being a real name was unintentional.

Thank you for that info about the 1983 TV movie, though. GRRM did start working in Hollywood in the 80s -- although not until 1985, he had just published The Armageddon Rag in '83 -- but it is possible he saw the movie when it was nationally broadcast on CBS. However, if he did, he's never mentioned it. Perhaps someone sometime could ask him about any perceived POTO connections...

[insert-game]

in a lot of ways i feel like i should have gotten a different degree because i feel as an adult my interests are much more creatively driven. but the culture insists that you decide your fate at age 17-19 and then have to stick with it for the rest of your life

[dkettchen]

absolutely unintelligeable meme I made during bootcamp lecture this morning

[hobgobbin]

"Ai art isn't actually bad it's capitalism that's bad and an economic model that's based on working the most possible so you think ai is just taking away your money"

This isn't abt artists mad abt losing a few commissions on the internet this is about large numbers of artists getting their art stolen so people can make something out of THEIR stuff, that they worked for years to create, without permision. AND corporations using free software to steal instead of paying artists properly. You would think with the amount of artists that are like 'hey this is bad and harming me', as well as the whole ass Hollywood-wide strike that happened with AI usage being one of the key talking points you would understand that it's bad and should at the very least have rules put around it.

But actually artists should stop focusing on something they can try to curtail before it gets too wildly out of control and instead focus on uhhhhh dismantling the economy if they're so mad their stuff is being stolen

[jcmarchi]

A Few Ways That Cloudways Makes Running This Site a Little Easier

New Post has been published on https://thedigitalinsider.com/a-few-ways-that-cloudways-makes-running-this-site-a-little-easier/

A Few Ways That Cloudways Makes Running This Site a Little Easier

It’s probably no surprise to you that CSS-Tricks is (proudly) hosted on Cloudways, DigitalOcean’s managed hosting arm. Given both CSS-Tricks and Cloudways are part of DigitalOcean, it was just a matter of time before we’d come together this way. And here we are!

We were previously hosted on Flywheel which was a fairly boutique WordPress hosting provider until WP Engine purchased it years back. And, to be very honest and up-front, Flywheel served us extremely well. There reached a point when it became pretty clear that CSS-Tricks was simply too big for Flywheel to scale along. That might’ve led us to try out WP Engine in the absence of Cloudways… but it’s probably good that never came to fruition considering recent events.

Anyway, moving hosts always means at least a smidge of contest-switching. Different server names with different configurations with different user accounts with different controls.

We’re a pretty low-maintenance operation around here, so being on a fully managed host is a benefit because I see very little of the day-to-day nuance that happens on our server. The Cloudways team took care of all the heavy lifting of migrating us and making sure we were set up with everything we needed, from SFTP accounts and database access to a staging environment and deployment points.

Our development flow used to go something like this:

Fire up Local (Flywheel’s local development app)

Futz around with local development

Push to main

Let a CI/CD pipeline publish the changes

I know, ridiculously simple. But it was also riddled with errors because we didn’t always want to publish changes on push. There was a real human margin of error in there, especially when handling WordPress updates. We could have (and should have) had some sort of staging environment rather than blindly trusting what was working locally. But again, we’re kinduva a ragtag team despite the big corporate backing.

The flow now looks like this:

Fire up Local (we still use it!)

Futz around with local development

Push to main

Publish to staging

Publish to production

This is something we could have set up in Flywheel but was trivial with Cloudways. I gave up some automation for quality assurance’s sake. Switching environments in Cloudways is a single click and I like a little manual friction to feel like I have some control in the process. That might not scale well for large teams on an enterprise project, but that’s not really what Cloudways is all about — that’s why we have DigitalOcean!

See that baseline-status-widget branch in the dropdown? That’s a little feature I’m playing with (and will post about later). I like that GitHub is integrated directly into the Cloudways UI so I can experiment with it in whatever environment I want, even before merging it with either the staging or master branches. It makes testing a whole lot easier and way less error-prone than triggering auto-deployments in every which way.

Here’s another nicety: I get a good snapshot of the differences between my environments through Cloudways monitoring. For example, I was attempting to update our copy of the Gravity Forms plugin just this morning. It worked locally but triggered a fatal in staging. I went in and tried to sniff out what was up with the staging environment, so I headed to the Vulnerability Scanner and saw that staging was running an older version of WordPress compared to what was running locally and in production. (We don’t version control WordPress core, so that was an easy miss.)

I hypothesized that the newer version of Gravity Forms had a conflict with the older version of WordPress, and this made it ridiculously easy to test my assertion. Turns out that was correct and I was confident that pushing to production was safe and sound — which it was.

That little incident inspired me to share a little about what I’ve liked about Cloudways so far. You’ll notice that we don’t push our products too hard around here. Anytime you experience something delightful — whatever it is — is a good time to blog about it and this was clearly one of those times.

I’d be remiss if I didn’t mention that Cloudways is ideal for any size or type of WordPress site. It’s one of the few hosts that will let you BOYO cloud, so to speak, where you can hold your work on a cloud server (like a DigitalOcean droplet, for instance) and let Cloudways manage the hosting, giving you all the freedom to scale when needed on top of the benefits of having a managed host. So, if you need a fully managed, autoscaling hosting solution for WordPress like we do here at CSS-Tricks, Cloudways has you covered.

[okayto]

I'm having to use Google Scholar for an assignment and my gosh it is such a PAIN to try and narrow down results or refine searches.

Don't get me wrong it's a good tool (I normally use it to see if I can find full text for something not in a library database, or for just a cursory search for a topic I'm not diving into), but it seems so annoying to refine results. I've known some people who used it as their primary research tool for grad school instead of ever opening a library database and I'm getting a headache just thinking about it.

[scvnthorpe]

That time I restored a Database view

Recently at work we've been migrating an old database system to a new platform to save money - this kind of shit is what makes your business processes faster, cheaper and more correct - and this has entailed sifting through a lot of tables, views, and views made of tables and views!

As it happens the finance guy who does all the payroll and expenses is a great guy to work with and basically the one person who knows all the relevant business rules, but also basically treats databases like they're excel workbooks. As such you have a bunch of bits stitched to each other and we're just figuring out how to first move everything and then ease into a well-oiled relational model with no duplication and all together on a single database.

While we in the dev team were figuring out how to do this for finance we were recently testing out a modified version of a view built on top of the old version and accidentally deleted the old version and not the modified testing version.

Mistakes are bound to happen, but we needed to figure out how to either restore it or at least figure out how to work without it because finance people love their data views and reports. There are probably clever things you can do with any DBMS to find shit you just dropped and restore it from backup, but I then realised that I'd been tasked with generating all the scripts for the database objects. There had to be a script laying around!

Sure enough I went to dig up the build script for the dropped view, and I ran it.

I queried it, and everything was back in place.

Shit goes wrong sometimes, but having the right failsafes can really make a difference.

Script your shit, use backups, use version control!

[musicrunsthroughmysoul]

Do I have to join a Bangles fan group on Facebook or something in order to find out who the hell played piano on their cover of "Going Down to Liverpool"?

[arshikasingh]

Why Use Java Interface?

An interface in Java is a blueprint of a class. It has static constants and abstract methods. There are three reasons due to which interface is used.

[raytaku]

So on my quest to build this web encyclopedia thing I've found out that not only personal use wikis are a thing, but business wikis are a thing too. Like. Wikis that the staff use for work stuff

Idk I thought that was neat

[kingsbridgelibraryteens]

FYI, if you have a library card (and if you don't, get one ASAP!) check your library's website for databases and other resources that are available FOR FREE for library members. For example, you can browse the New York Public Library's databases (many of which are available from anywhere with a NYPL library card number and PIN) here:

Skip Google for Research

As Google has worked to overtake the internet, its search algorithm has not just gotten worse.  It has been designed to prioritize advertisers and popular pages often times excluding pages and content that better matches your search terms 

As a writer in need of information for my stories, I find this unacceptable.  As a proponent of availability of information so the populace can actually educate itself, it is unforgivable.

Below is a concise list of useful research sites compiled by Edward Clark over on Facebook. I was familiar with some, but not all of these.

⁂

Google is so powerful that it “hides” other search systems from us. We just don’t know the existence of most of them. Meanwhile, there are still a huge number of excellent searchers in the world who specialize in books, science, other smart information. Keep a list of sites you never heard of.

www.refseek.com - Academic Resource Search. More than a billion sources: encyclopedia, monographies, magazines.

www.worldcat.org - a search for the contents of 20 thousand worldwide libraries. Find out where lies the nearest rare book you need.

https://link.springer.com - access to more than 10 million scientific documents: books, articles, research protocols.

www.bioline.org.br is a library of scientific bioscience journals published in developing countries.

http://repec.org - volunteers from 102 countries have collected almost 4 million publications on economics and related science.

www.science.gov is an American state search engine on 2200+ scientific sites. More than 200 million articles are indexed.

www.pdfdrive.com is the largest website for free download of books in PDF format. Claiming over 225 million names.

www.base-search.net is one of the most powerful researches on academic studies texts. More than 100 million scientific documents, 70% of them are free

[insert-game]

i hate gen AI so much i wish crab raves upon it

[track-maniac]

for context i'm looking at the code i wrote back when i made this post and uh

yay! hardcoded secrets!

in the gitted lab. straight up "pushing it". and by "it", haha, well. let's just say. Bad code

[arshikasingh]

Why Choose Java?

There are several features of Java due to which Java is popular for software development.

Simple Object-Oriented Portable Platform independent Secured Robust Architecture neutral Interpreted High Performance Multithreaded Distributed Dynamic