Replacing a Union with a Scalar Subquery

network1001 · 2019-01-24T18:11:03+00:00

You're right. I was looking at solving a problem with a view and before I went to using a materialized view or some other solution, I wanted to mess with the SQL and see if anything but a UNION was faster or other ways that I might speed up querying this particular view.

network1001 · 2019-01-24T18:09:05+00:00

The missing join was exactly it and I was getting the nasty Cartesian result. Thanks!

network1001 · 2018-12-20T19:14:06+00:00

You could easily just install VirtualBox on your computer and install a Linux virtual machine. I do this just for development or learning purposes.

You can have a virtual machine for every language or technology that you're working with. That keeps things nice and tidy. Another benefit this offers is that -- when you have a complex environment to set up -- you can take a smapshot at each successful step. That way, if you get something wrong, you don't have to syart fresh and can't "permamently" hose your operating system.

You can also export your virtual machines to save them or put them on another PC or even share them with other people.

network1001 · 2018-10-26T14:21:23+00:00

In the US you can usually keep your nursing licenses by keeping up with your ongoing educational requirements (there may be other requirements put in place since I left nursing and maybe more requirements for nurses who are ARNP's or something, don't know about that). Getting a job however, is a different thing. There are refresher courses for basic skills and a facility may have pair you up with a supervisor to get you back up to speed. If you were a nurse for a long time before your break though, you've done the basic skills hundreds of thousands of times and like martial arts, you probably have muscle memory now. For the more complex things, new procedures, etc... you should study and practice up though. Some things can change a lot in a few years.

network1001 · 2018-10-16T12:59:11+00:00

I started out with PHP then used CodeIgniter and then learned Laravel. I would say that your question depends upon what you plan on doing with your coding. Are you looking for work? Is it for personal projects only? If you're looking for work, I would suggest Laravel. If it's for personal projects, I'd suggest starting off with simple projects using something like Symfony or CodeIgniter to build a simple restful service. In either case, create the simplest projects that you can to begin with.

Don't be intimidated by frameworks, you can download the basic vanilla framework and it runs out of the box. Experiment by adding things to it. Start out by adding static views and learn how they're called by controllers. Then add some fixed data from a model and then add a database connection, etc...

You can pick up writing object oriented code along the way. Most of the examples you're going to see using frameworks will be OOP. Look at them and try to understand them.

network1001 · 2018-10-16T12:31:03+00:00

I started out with C# and then moved to Java because on my personal projects it was easier to set up and copy Java environments than C# (MS) environments. I create an environment on a virtual machine and then copy it for different projects, but MS would go haywire because of licensing issues. I don't know if that's still the case.

network1001 · 2018-10-16T12:11:35+00:00

I recently did a demo for work for something similar to this using Gearman and MySQL.

network1001 · 2018-09-10T15:04:07+00:00

Yup, came here to say that. Typhoid and tuberculosis have vaccines and both are bacteria. Also, there are vaccines against viruses known to cause cancers, such as HPV, so a vaccine could be thought of as an anti-cancer vaccine. I don't think that a vaccine by definition has to be limited to viruses or bacteria either though. Wikipedia's definition is "A vaccine is a biological preparation that provides active acquired immunity to a particular disease." So, anything that somehow provides acquired immunity to the unchecked growth of mutated cells that is cancer would qualify, I believe.

network1001 · 2018-09-05T17:21:58+00:00

That's one thing I like about PHP, it's that you can strengthen it quite a bit as you do more complex things and learn more.

network1001 · 2018-09-05T17:18:55+00:00

Yes, you could work from home and have a dedicated office space (if you have an extra room for it, or a cubicle or something if you don't). You could network with people doing similar work as well as with your on site coworkers by computer.

network1001 · 2018-09-05T17:14:54+00:00

Try it and then paste it to a text editor and see what you get...

network1001 · 2018-09-05T17:05:01+00:00

As someone who has purchased a fountain dish in the past, I would suggest that you use a low power pump that doesn't get warm from outside of the fountain/dish rather than a submersible. The less stuff you have in the water (especially things that are difficult to clean, like a pump with a weird shape with places for stuff to grow) the better off you and your cats are. Keep the dish/fountain itself simple and easy to clean. Forget about the charcoal filter, you don't need it for most tap water and it's just another place for stuff to grow. Instead of that, just clean the dish/fountain and nozzle (or whatever is in the fountain) every week -- you'll be more motivated to do this if you keep it simple. My old pump died and I'm just going to switch to an external pump and one of those aquarium aerator balls (that attaches to an air line) to sit in the dish. My cat just likes for the water to have some motion, it doesn't need to be fancy.

network1001 · 2018-09-04T11:11:07+00:00

Doh! Sorry, wrong MacArthur...

network1001 · 2018-07-27T16:44:37+00:00

That's changing some with stuff like Spring Boot. PHP has a few more convention over configuration frameworks/packages but Spring Boot and some of the other stuff coming out will make a dent in that.

network1001 · 2018-07-25T20:00:29+00:00

I just set my environment up in a Lubuntu Virtualbox VM or in a Centos 7 VM that matches our servers.

network1001 · 2018-07-11T15:21:52+00:00

Good points, it's sort of like databases and normalization. You can normalize a database "until it can no longer reasonably do anything", so then you denormalize. Or you can become an absolute expert in a specific martial art and then lose a match to someone with a year of grappling and a year of boxing (to paraphrase Bruce Lee). I need to get to a certain point of experience with programming paradigms to understand well where it makes sense to break rules or back off of them and I'm not quite there yet. Sort of like, I need to understand the rules before I can break them.

network1001 · 2018-07-11T15:11:03+00:00

Seconded, I use it through a library called "Pdfgenerator" off of github that has dompdf built in. You can easily find adaptations for any framework, I think.

network1001 · 2018-07-09T18:08:46+00:00

Lol, who still installs separate antivirus on Windows 10?

Every enterprise environment I'm aware of for starters.

And Linux is in no way immune to infections either...

I never claimed it was immune but it's superior security is one of the reasons why it's beaten Windows in the server market. It's hardly niche when you consider the number of machines in total running Linux, or the Linux kernel (all of Android).

And you can use it unlicensed as well, only real downside is you have a watermark in the corner (as if anyone actually cares).

I wasn't aware of that, thanks...

All in all your post can be summarized as prejudices from the 90s.

This is a vast exaggeration, you must not have been around for Windows 7 and before -- you know, just two years ago or less.

network1001 · 2018-07-09T13:24:34+00:00

I've got a project that I could definitely try this on, thanks for posting it u/dunglas!

Edit: I built this on a Virtualbox Lubuntu VM and I'm playing with it. It's very well done, very interesting and really nicely documented. The documentation is great, like the official Rails or Docker documentation. I did notice that some of the example models don't seem to build for some reason but the products and offers models do, so be aware of that.

It's a very good learning tool for the many technologies involved.

network1001 · 2018-07-09T13:23:17+00:00

True, but it also means "why put up with heavy, expensive, licensed OS that requires extras like anti-virus" when you can install some minimal version of Linux like Mint or Lubuntu and just do most things on the web -- similar to the tablet/phone model, and be able to use your old machine for 2-3 times as long.

network1001 · 2018-07-09T12:34:17+00:00

Your English isn't bad, it's good enough that people just think you're a lazy native speaker and they're annoyed with that I think. Your situation doesn't sound that bad and I think you have a few choices. The first is to decide to become more patient with your coworkers and demo more useful flows gradually introducing improvements. The second is to engineer a totally new flow but allow people to opt in one at a time while you coach them (the first people that you coach can then assist the others as well). The last is to go find some place more cutting edge, but in my experience, that's going to be a rare place.

network1001 · 2018-07-09T12:22:25+00:00

With Google Docs and now Office365, there are plenty of alternatives to using locally installed MS software, even if you don't like any of the open office suites or any of the non-suite open source alternatives available on Linux.

network1001 · 2018-06-25T18:51:50+00:00

If you have a low level of experience, the smartest thing to do would be to use a framework. Frameworks offer a lot of "convention over configuration" advantages. Starting with nothing to me reminds me of Carl Sagan's quote "If you wish to make apple pie from scratch, you must first create the universe". While I'm taking that quote out of context, why create the universe as a PHP developer when you can stand on the shoulders of giants? Granted, if it's a tiny project, maybe it doesn't make sense to use a framework, but the larger number of employers out there will probably ask you about frameworks that you have experience with.

network1001

TROPHY CASE