One of the nice things about MySQL 8.0 is the ability to combine the relational and document models. As a developer, you can choose to work with traditional SQL tables, with schemaless JSON documents, or with both types at the same time. Here we show how to bridge SQL tables and JSON documents by using JSON functions. Enjoy!
First, let us create a simple SQL Table “employees” and insert some values:
Here we use two JSON aggregation functions called JSON_ARRAYAGG() and JSON_OBJECT(). We simply select from employees and convert the result set into JSON like this:
mysql>SET@jsonempl=(SELECTJSON_ARRAYAGG(
–>JSON_OBJECT(“id”,id,“name”,name,“age”,age))
–>FROMemployees);
QueryOK,0rowsaffected(0,00sec)
We now have a JSON Document referenced by the variable @jsonempl. Let us look at it using the JSON_PRETTY() function:
Here we use the JSON table function called JSON_TABLE(). This function creates an SQL view on the JSON Document, i.e. a mapping between JSON and SQL. We then wrap a CREATE TABLE employees AS around it like this:
Wipers should smoothly clear water, snow, and slush from your windshield with no squeaking, chattering, skipping, or grabbing. If you notice these signs, or if a wiper is leaving streaks or bands of water, it may be time for new ones. When long-term testing our picks, they typically worked well for about nine months to a year before showing signs of wear, although this varied, depending on the conditions, the type of wiper, and how well they were maintained. Sure, wipers see a lot of action in wetter and snowier areas, but even in the southwest, where you can go months without rain, they can degrade quickly. The constant heat, dryness, and sunlight can deteriorate the rubber element; we’ve even seen long-unused wipers that had to be peeled off of the windshield glass. So, in those conditions, it’s good to run your wipers about once a week while spraying the windshield with washer fluid.
When we asked representatives from several service shops about problems they’d seen caused by worn, neglected wipers, the answers were both similar and convincing. “I personally have seen people wait so long that the blade becomes old and brittle, and it damages the window,” says Joe Betancourt Jr., VP of Joe’s Expert Auto in Chicago. “In some cases, the blade comes off with the backing and the arm will gouge the glass, causing an expensive and unneeded repair.”
Pete McAdoo, of Honest-1 Auto Care in Portland, agrees, “I’ve seen them come off, come apart to where they scratch the glass. And now they have an etching of the sweep of the wiper on the glass.” McAdoo has also seen disintegrated wipers get hung up on something and damage the wiper motor: over a prolonged period of time, even a wiper that’s chattering and dragging on the windshield “puts stress on the motor and linkage,” which can shorten their service life. “Change them on a regular basis,” he advices. Travis Decker, of Portland’s Atomic Auto Service, agrees: “Wipers are cheap insurance” against more costly repairs.
If you notice your wipers having problems, first try cleaning the rubber blade. Sometimes that’s all it takes to get a few more weeks or months from your existing wipers. Dip a clean paper towel or cloth in a little water, washer fluid, or rubbing alcohol and wipe along the edge of the blade. Also, look at it closely and feel for any adhered debris or roughness. The edge should be sharp and smooth without any nicks, chips, or gaps, and the rubber should be pliable, not cracked or brittle.
In the winter, thoroughly scrape ice off of the windshield before using the wipers, as ice can abrade the rubber and dull or damage the edge.
Geoff Helzer, of Portland’s Green Drop Garage, says that another common problem he’s seen is a film that builds up on the windshield from oily, greasy road-grime spray. “The film can be removed by using a windshield stripper product that does a deep clean of the windshield surface,” he says. It requires some elbow grease, but “has proven to be very effective in returning the glass to a like-new condition.”
If cleaning doesn’t help the wipers, it’s time for new ones. And always replace them in pairs, because if one wears out, the other won’t be far behind.
While a lot of people wait for these problem signs to appear before buying new wipers, it’s better to be proactive and replace them before you need to. Not being able to see clearly in a sudden downpour or heavy snow or ice storm can be a real drag, not to mention dangerous. And then there’s that “cheap insurance” thing, too—it’s better to replace them before they wear to the point where they can cause damage to the car.
So, how often should you replace your wipers? Wiper manufacturers and a couple of the shops we talked to suggest replacing them every six months. But once per year may be a reasonable interval for you. In an online poll we conducted, about a quarter of respondents said they replace their wipers about every nine to 12 months, while about a fifth said every 12 to 18 months. Almost as many—18 percent—agreed that we summed up their thinking on the issue with the question, “Wait. Wiper blades don’t last forever?”
Travis Decker, of Atomic Auto Service, recommends to replace them as needed, but that depends on the climate. “Here, in Oregon, I suggest every fall.” Joe Betancourt, of Joe’s Expert Auto, says, “In areas like where we are (Chicago), I recommend every 3 to 4 months during the winter season, due to icing on the windshield.”
If you have a tough time remembering to get new blades, tie the task to another regular event. The windshield wiper industry has tried to co-opt Groundhog Day as national “replace your wipers day,” so you can use that if it works for you.
For years we’ve documented how the internet of broken things industry and evangelists have contributed to a global privacy and security shitshow. The rush to connect everything from tea kettles to Barbie dolls to the internet without including even basic privacy or security standards has resulted in a massive security problem few seem interested in actually fixing. As a result we’re not only less secure and more at risk for privacy violations, but these devices are now routinely contributing to some of the most devastating DDoS attacks history has ever seen.
A year or so ago Bruce Schneier penned what was probably the best explanation of why nothing in the IOT chain of dysfunction seems to improve:
"The market can’t fix this because neither the buyer nor the seller cares. Think of all the CCTV cameras and DVRs used in the attack against Brian Krebs. The owners of those devices don’t care. Their devices were cheap to buy, they still work, and they don’t even know Brian. The sellers of those devices don’t care: they’re now selling newer and better models, and the original buyers only cared about price and features. There is no market solution because the insecurity is what economists call an externality: it’s an effect of the purchasing decision that affects other people. Think of it kind of like invisible pollution."
Instead of fixing their products, vendors simply move on to marketing the next best thing. And consumers continue to gobble them up, creating millions of millions of new attack vectors into homes and businesses around the world annually. Obviously this "invisible pollution" continues to have a very real and visible impact. Case in point: Nicole Eagan, the CEO of cybersecurity firm Darktrace, says hackers are increasingly targeting unprotected IOT devices including air conditioners, toys, and surveillance cameras to get into corporate networks.
She noted how one bank that decided to skimp on security cameras actually wound up being hacked after those cameras were quickly compromised by attackers. Speaking at the WSJ CEO Council Conference, she also shared an anecdote about how one big casino client had their customers’ financial histories stolen thanks to an internet-of-broken things aquarium thermostat:
"Eagan gave one memorable anecdote about a case Darktrace worked on in which a casino was hacked via a thermometer in an aquarium in the lobby. The attackers used that to get a foothold in the network," she said. "They then found the high-roller database and then pulled that back across the network, out the thermostat, and up to the cloud."
It’s understandable that people are wary of regulating this sector lest it stifle innovation or create unforeseen, additional problems. But it’s pretty clear we’re going to need a massive collaboration between the public, companies, and government if we want to avoid some potentially calamitous and fatal outcomes (especially if and when essential infrastructure is targeted). That’s why what the open source IOT security and privacy standards organizations like Consumer Reports have been cooking up desperately need all the public and private sector support they can get.
Gun writer Tom Mchale lets us in on his five must-own shooting accessories.
This UM Tactical Pistol Optics Mount shooting accessories comes in handy for accuracy testing guns and ammo. I keep a Bushnell 3500 Handgun Scope on it for that purpose.
USA –-(Ammoland.com)- There’s always something new and cool on the gun gear shooting accessories market. People like you and I often get excited about something or another because it seems like such a good idea, or so handy, or maybe it’s such a great deal. Like most other product categories, shooting gear must pass the test of time for it to make the true favorites list. Once the shiny new novelty wears off, do you still find the same value from that piece of gear? Here are a few shooting accessories that have survived many of my ruthless range bag reorganizations.
MantisX Shooting Performance System Shooting Accessories
We all put in an hour or so per day of dry-fire practice, right? What? You don’t? Well, disregarding the fact that we have plenty of other things to accomplish and that dry-fire practice has been known to induce boredom comas, some slippage in the daily schedule is understandable.
Here’s one shooting accessories that’s made practice either at home or the range much, much more interesting and effective. The MantisX Shooting Performance System consists of a small, light, and rechargeable device that you mount to the rail of your pistol and a smartphone app. As you might guess, these two things communicate. Oh, if your gun doesn’t have a rail, check the MantisX.com website – they offer adapters.
The MantisX system uses Bluetooth to send performance data to a smartphone app.
Anyway, the MantisX has magic sensors that detect the slightest movement prior to, during, and immediately after the trigger press. This data is sent to the smartphone app so you can see what you’re doing graphically. The app also assigns numerical scores to each shot based on the amount of movement through your shot. The company has been continuously updating the app so it now includes structured drill and training routines you can use to measure progress against skills over time. You can also set up accountability groups with friends to share results.
Here’s what makes the MantisX extra super nifty. Not only can you hone your skills dry-firing at home, but you can also stick this on a CO2 pellet or BB pistol to simulate some noise and recoil. Lose the pellets, and you can shoot blasts of air inside your house, at least when your spouse is out running errands. Better yet, take it to the real range and run it with live ammo. It’ll tell you exactly why you’re hitting or missing.
UM Tactical Pistol Optics Mount
As shooting accessories go, I’ve been using the UM Tactical Pistol Optics Mount for a couple of years now, so it’s proven its utility over the long haul. Here’s what it does.
The device hooks to the rail under the muzzle and wraps around both sides of the frame and slide, without touching, meeting again maybe a half-inch over the slide. At the top, the two halves join to form a Picatinny rail segment on which you can mount a red dot sight or magnified handgun scope. Since nothing touches the slide, your pistol functions through recoil normally and the rail and mounted sight don’t move at all.
Being able to mount a red dot sight on a pistol not originally designed for one is cool and plenty of fun. Mounting a magnified handgun scope on your favorite pistol opens up all sorts of possibilities. If you’ve got an accurate gun, it’s no big thing to hit targets 100 yards or farther with ease. I use it for precise accuracy testing at 25 yards because the scope completely removes the issue of shooting sighting error. It also makes an interesting solution for long-range plinking or hunting provided you have the right caliber/game match.
Blue Force Gear Double Pistol Belt Pouches
Sometimes the simplest shooting accessories are the handiest. That also can (rarely as in this case) apply to the least expensive things. While I’m sure, you can find magazine pouches for a few pennies less (the MSRP of these guys is $26.00) it’ll be hard to match the durability and usefulness.
The industrial elastic Blue Force Gear Double Pistol Belt Pouches are one size fits any.
The Blue Force Gear Double Pistol Belt Pouches define “zero bulk” as the front and back surfaces add mere millimeters (if that) to the thickness of your magazines. The back is a cloth laminate called ULTRAcomp that’s flexible but super tough. The front is made from military-grade elastic. That means that the pouches stretch to accommodate magazines of any size: single, stack, double-stack, and caliber of your choice. This elastic does spring back to original size so you can stick fat double-stack magazines in one day and singles the next. The belt loops are constructed from hook and loop material. That’s tacti-speak for Velco. You can size the dual belt loops to any belt width up to two inches.
The versatility is great, but one reason the Blue Force Gear Double Pistol Belt Pouches make the favorite five shooting accessories list because they’re soft and flexible – great for concealed carry. Also, there’s nothing that says you have to carry two magazines. If you like, you can carry one and some other piece of gear. I often stick a multi-tool or flashlight in the second pouch.
Nothing says you have to use both pouches for magazines. I often carry a multi-tool, knife, or flashlight in the second pouch.
Etymotic GunSport Pro Electronic Ear Plugs
I live in Sub Sauna Carolina. It’s hot for at least 592 days per year. It’s not only hot but steamy humid. So, all the great advancements in low-cost electronic hearing muffs still end up as a sweaty mess on my head. Those also tend to press safety glasses frames into your temples, making a permanent moat between your eyes and ears. Sure, you can use foam ear plugs, and they work great provided you don’t want to hear anything at all. Or, you can drop a couple of grand on custom-molded in-ear electronic plugs. Or…
You can invest about $300 in a set of Etymotic GunSport Pro electronic plugs. That’s not pocket change, and if you are a once-per-year shooter, they’re probably not for you. However, if you frequent the range or compete, they pay for themselves really quickly in comfort and convenience. The kit includes six different sets of ear tips so you can achieve a perfect fit that won’t give you an earache. When I go to events and training classes, I’ll just leave them in all day long – they’re that comfortable.
Etymotic GunSport Pro Electronic Ear Plugs
The Etymotic GunSport Pro Electronic Ear Plugs dampen gunshot noise to hearing-safe levels. An alternate setting magnifies nearby sounds by 5x while still providing protection again dangerous noise levels. That’s handy for hunting or hearing range commands clearly. I’ve tried lots of others, and these take the cake for their excellent and very natural sound quality. That combined with all-day comfort lets you forget you’re wearing them. One more thing. Unlike large over-the-ear muffs, these don’t get in the way when shooting rifles and shotguns.
Hoppe’s Gun Medic Cleaner and Lube Quick Fix
I don’t know about you, but I thoroughly clean my guns immediately after range outings – or at least as often as every 10 or 57 times I go shooting. I used to be a shoot once, clean once kind of guy, but I figured out, concurrent with the onset of male pattern laziness, that modern guns work pretty darn well and don’t really need to be cleaned every couple of dozen shots. Not to mention all that taking apart and cleaning multiplies the odds that you won’t put something back in place just right. Unless you clean your guns at the range after your done shooting and can fire a couple of test shots, you don’t really know for double-secret-sure that your gun is in proper functioning order.
Hoppe’s Gun Medic Cleaner and Lube
My less than rigorous training routine is one of the reasons I always carry a bottle of gun Hoppe’s Gun Medic Cleaner and Lube Quick Fix in my shooting bag. The combo cleaner and lube comes in an aerosol can. The cleaner blasts the nasty stuff away and then evaporates, leaving a thin layer of lube behind. To be clear, this combo packaging is for exactly what the name says – a quick fix. The idea is to get your gun working when it’s sluggish from filth without having to field strip and start cleaning. Just spray in the action or through the ejection port. It works like a champ on semi-automatic pistols and AR-type rifles. If you like the lube, you can buy the cleaner and lube separately for proper apres-range cleaning.
So, my favorite five shooting accessories? Yes, if I weigh the choices based on what I’ve actually ended up using consistently over the long haul.
Tom McHale
About
Tom McHale is the author of the Practical Guides book series that guides new and experienced shooters alike in a fun, approachable, and practical way. His books are available in print and eBook format on Amazon. You can also find him on Facebook, Twitter, Instagram and Pinterest.
Apple hardware is often cited for reliability, but you can end up with an expensive fix when something goes wrong. That’s why it’s great if you’re able to perform your own hardware tests before approaching an Apple professional about a potential fix.
Thankfully, testing your Mac at home is free, simple, and takes only a matter of minutes.
Apple Hardware Test or Apple Diagnostics?
Which version of Apple’s hardware test you’ll use depends on the age of your Mac. Computers released before June 2013 will use Apple Hardware Test. Computers released after June 2013 will use Apple Diagnostics instead.
The older Apple Hardware Test (AHT) doesn’t provide as much information about your system as Apple Diagnostics. It runs cursory tests on components and determines whether they are present and operable. The results are fairly easy to interpret, but not particularly detailed.
Apple Diagnostics provides more information about your Mac’s hardware than AHT. At the end of the test, you’ll get an error code which you can use to help decide which hardware components are having an issue and what to do about it.
Neither of these tests are as conclusive as Apple Service Diagnostics (ASD), which is Apple’s own in-house testing. If you take your Mac to an Apple Store for a Genius Bar appointment, they’ll hook up an Ethernet cable and run ASD to get far more detailed results about the status of your machine.
My iMac is having some serious issues with the HD. Found Apple Service Diagnostics to run on it. I have a feeling that I’ll need to buy a new HD.
Regardless of which diagnostic tool you’re using, the method for testing your Mac is the same:
Shut down your Mac.
Disconnect all external devices except your keyboard, mouse, display, wired network connection (if you have one), and power cable.
Turn on your Mac and immediately press and hold the D key.
Release the D key when the Hardware Test or Diagnostics tool appears onscreen.
Select your language.
If you’re using the older Apple Hardware Test there’s one more step: press the T key to begin the testing procedure. You can also check Perform extended testing to run a more thorough and time-consuming diagnostic. If you’re using Apple Diagnostics, you only need to specify your language.
You will see your results onscreen once the scan is complete. Make a note of any reference codes you receive, since you’ll use those to interpret your results in the next section.
Help! My Mac Won’t Run Diagnostics
It’s possible your older Mac doesn’t include the diagnostic tool on its disk. If your disk or startup partition is damaged, this may cause the diagnostic test to not run at all. In this instance you’ll need to run the diagnostic via the internet.
It’s easy to do, but it will take longer since you’ll need to download the relevant tool before you can begin the procedure. In order to run a diagnostic test from the internet, follow the same procedure outlined in the section above but hold the Option + D keys instead of just D.
You’ll need access to the internet via a wired or wireless connection for this to work.
Interpreting Your Diagnostic Results
Apple Hardware Test should provide some fairly easy-to-understand diagnoses, including reference codes. I tested an old MacBook Air that has no battery in it, and the AHT report and reference code matched up.
If you’re using Apple Diagnostics, you’ll have a greater array of codes at your disposal. You can cross-reference them using the Apple Support reference codes list. Some notable reference codes include:
ADP001: Good news! This means no errors were detected.
NDD001: Possible problems with USB hardware; make sure all USB devices are disconnected.
PPM001-015: Possible problem with computer memory.
PPR001: Possible problem with CPU.
PPT001: Battery not detected.
VFD006: Possible problem with GPU.
VFF001: Possible problem with audio hardware.
While these codes only provide a limited amount of information, it might be enough to point you in the right direction. If you’re getting battery errors, it’s probably time to replace your battery. You might even be able to save a few bucks by fixing it yourself Fix Your Own Mac: A Troubleshooting Guide
Fix Your Own Mac: A Troubleshooting Guide Apple is known for having great customer service and repair technicians, but if you’re no longer under warranty that expertise doesn’t come cheap. Why not try troubleshooting your own Mac first next time? Read More
.
Others codes might raise more questions than answers. If you’re getting memory errors, it’s probably worth following up with a more in-depth testing tool. We recommend a free tool called memtest86, which you can run from USB for a detailed scan.
Other problems are tricker to resolve. If you’re getting errors about your Wi-Fi or Bluetooth hardware, it might be worth spending a small amount of money on a USB adapter that offers a workaround for dodgy internal hardware.
Problems with your main processor or graphics processor are harder to isolate and resolve. Further, you might find that your computer passes Apple’s tests but still has issues. At this stage, it’s probably worth talking to a professional or considering a replacement model 6 Signs It’s Time to Upgrade or Replace Your Mac
While it’s not as easy as repairing a Windows PC, you can fix Apple hardware at home. Be aware that if your machine is old, the cost of Apple’s expensive parts might not be justified when you take the price of a new machine into account.
On Tuesday Red Hat announced the general availability of Red Hat Enterprise Linux version 7.5.
An anonymous reader writes:
Serving as a consistent foundation for hybrid cloud environments, Red Hat Enterprise Linux 7.5 provides enhanced security and compliance controls, tools to reduce storage costs, and improved usability, as well as further integration with Microsoft Windows infrastructure both on-premise and in Microsoft Azure.
New features include a large combination of Ansible Automation with OpenSCAP, and LUKS-encrypted removable storage devices can be now automatically unlocked using NBDE. The Gnome shell has been re-based to version 3.26, the Kernel version is 3.10.0-862, and the kernel-alt packages include kernel version
4.14 with support for 64-bit ARM, IBM POWER9 (little endian), and IBM z Systems, while KVM virtualization is now supported on IBM POWER8/POWER9 systems.
USA – -(Ammoland.com)- On Friday, April 6, 2018, U.S. District Judge William Young said assault weapons are military firearms and aren’t protected by the constitutional right to “bear arms.” However, he couldn’t be more wrong.
First and foremost, the term “Assault-Weapon” is a made up term by the gun control lobby to strike fear into the hearts and minds of Americans. Gun control activists rely very heavily on fear-based language to pursued Americans that guns are naturally evil, and that the only solution is to pass stricter gun control laws.
Assault is an action; it’s a verb, not a noun. Firearms have no soul, they’re not living objects, and they are not inherently evil. You could put a loaded firearm on a table, leave it there, and unless somebody picks it up, aims it, and pulls the trigger; the firearm will remain harmless. Which settles the debate of “guns don’t kill people, people kill people.”
The origin of this term “Assault-Weapon” is not one hundred percent clear. According to the Nexis News database, the first mention of “assault weapons” appears in a 1980 New York Times story. Over the past several decades, gun-control proponents have heavily relied on this terminology and have blanket-applied it to any firearm that looks scary.
Secondly, gun-control proponents now slap on the term “assault” to any firearm they don’t like or want to be restricted from public use. The public mistakes the “AR” in AR-15 to mean “assault rifle,” while fake news headquarters CNN, frequently refers to AR-15’s as “assault rifles.” The “AR” in “AR-15” stands for “ArmaLite,” the company that first manufactured the AR-15 in December 1959.
Thirdly, addressing the issue of the “AR-15” and how dangerous it is. These semi-automatic rifles, not “fully automatic machine guns” as some gun control puppets, like Whoopi Goldberg, would have you think. Semi auto firearms have been in public circulation for more than 60 years. It wasn’t until almost 50 years later that we saw one used in a mass shooting.
Furthermore, if we look back at the recent mass murders committed with an AR-15, we see a trend that these criminals should not have had access to a firearm in the first place or law enforcement failed to act upon credible information.
Nikolas Cruz – Parkland massacre. Police visited Cruz’s home more than 30 times since 2011. Even worse, the FBI had received to tips about Cruz before he committed his horrible act. The first on September 24, 2017, when Cruz posted the comment “I’m going to be a professional school shooter” on a YouTube video, and the second on January 5, 2018, when an anonymous person called the FBI to warn them about Cruz. The FBI admitted to not following established follow up protocols. “Under established protocols, the information provided by the caller should have been assessed as a potential threat to life,” the FBI said.
Devin Patrick Kelley – Sutherland, Texas Church massacre. Kelley should not have had access to firearms, according to Texas Governor Abbott and current federal law. Kelley was dishonorably discharged from the military, which automatically bars someone from ever purchasing firearms again. Omar Mateen – Pulse Nightclub massacre. Mateen had been on the FBI’s suspected terrorist list, investigated twice by the FBI for terrorism, and convicted of misdemeanor hate crimes.
Syed Rizwan Farook and Tashfeen Malik – San Bernardino massacre. According to then FBI Director James Comey, both were “radicalized” before they started dating each other and that they were “homegrown violent extremists” who were “inspired by foreign terrorist organizations.” Farook and Malik did not purchase their firearms. The firearms used in the massacre were a “straw purchase” bought by Enrique Marquez Jr., who pleaded guilty in February 2017. Fourthly and finally, an “assault weapons” ban certainly violates the Second Amendment. In 2008, Justice Scalia handed down one of the most historic, landmark decisions in the history of the United States Supreme Court. DC v. Heller held that “the Second Amendment protects an individual right to possess a firearm unconnected with service in a militia.”
In the majority’s opinion written by Justice Scalia, he states that the second amendment protects firearms that are in “common use.” The National Rifle Association estimates that there are more than eight million AR-15’s and its variations in circulation. The AR-15 has been in circulation and readily available for purchase by law-abiding citizens since 1959. And if you’re still not sold on the fact that AR-15’s, and its variations, are in “common use” you can read these self-defense stories from 2013 – 2018, in which an AR-15 saved lives and stopped crime.
About Tyler Yzaguirre
Tyler Yzaguirre is the co-founder and president of the Second Amendment Institute, which promotes gun rights through education and activism. Follow him at www.sainational.org .
For the first time in twenty years, as the Atlantic points out, a whole year’s worth of copyrighted works will enter the public domain in the U.S. on January 1, 2019. Under the terms of the Sonny Bono Copyright Act, works first published in 1923 will enter the public domain, meaning anyone can re-publish them, or chop them up and use them in other projects, without asking permission or paying the old rights holders. You can record new versions of the musical compositions; you can show the movies for a profit; you can even remake them. Amazon can sell you the ebook and keep all the money, and Project Gutenberg can give you the ebook for free. The Atlantic has a short list; we have a longer one below.
You can even make new copyrighted works based on the old works—the way Disney made all its cartoons based on public-domain fairy tales—and people can’t copy any of the new parts you include. (That’s why anyone can make movie about the fairy tale of Snow White and the seven dwarves, but only Disney can make new things where the dwarves are named Grumpy, Sleepy, Sneezy, Dopey, Happy, Bashful, and Doc.)
Advertisement
Speaking of Disney, they’re the ones who lobbied for such long copyright terms, because in 1998 Mickey Mouse’s first appearance (in the 1928 cartoon Steamboat Willie) was close to losing its copyright. But after the Sonny Bono Act, Now that first Mickey Mouse appearance will enter the public domain in 2024. Walt Disney had just started his company in 1923, but they hadn’t produced anything major. So we won’t get any free Disney stuff in January.
“The Charleston”—written to accompany, and a big factor in the popularity of, the Charleston dance
Igor Stravinsky’s “Octet for Wind Instruments”
And these songs I picked purely based on their titles:
“Back To Croa-Jingo-Long”
“I’m Sitting Pretty In A Pretty Little City”
“Come On, Spark Plug!”
“Dizzy Fingers”
“I’ve Got The Yes! We Have No Bananas Blues”
“When It’s Night-Time In Italy, It’s Wednesday Over Here”
“Oh Gee Oh Gosh Oh Golly I’m In Love”
“Old King Tut”
“Horsey, Keep Your Tail Up”
Note that these are published songbooks, not recordings, meaning you can record a cover version without permission or payment, but you can’t just steal any post-1923 recording. So Connie Francis’s version of “Who’s Sorry Now?” is still under copyright.
Advertisement
Even worse, rights over music recorded until 1972 is governed by state law, and if its copyright was registered and renewed, it doesn’t automatically enter the public domain until 2067.
Bambi by Felix Salten, illustrated by Barbara Cooney—the source of Disney’s animated film, and the first in a series
The Ego and the Id by Sigmund Freud
Towards a New Architecture by Le Corbusier
Whose Body?, the first Lord Peter Wimsey novel by Dorothy L. Sayers
Emily of New Moon, the first book of L.M. Montgomery’s Emily trilogy
The Inimitable Jeeves and Leave it to Psmith by P.G. Wodehouse
Two of Agatha Christie’s Hercule Poirot novels, The Murder of Roger Ackroyd and The Murder on the Links
The Prisoner, volume 5 of Marcel Proust’s In Search of Lost Time (note that English translations have their own copyrights)
The Complete Works of Anthony Trollope
George Bernard Shaw’s play Saint Joan
Short stories by Christie, Virginia Woolf, H.P. Lovecraft, Katherine Mansfield, and Ernest Hemingway
Poetry by Edna St. Vincent Millay, E.E. Cummings, William Carlos Williams, Rainer Maria Rilke, Wallace Stevens, Robert Frost, Sukumar Ray, and Pablo Neruda
Works by Jane Austen, D.H. Lawrence, Edith Wharton, Jorge Luis Borges, Mikhail Bulgakov, Jean Cocteau, Italo Svevo, Aldous Huxley, Winston Churchill, G.K. Chesterton, Maria Montessori, Lu Xun, Joseph Conrad, Zane Grey, H.G. Wells, and Edgar Rice Burroughs
Marcel Duchamp’s The Bride Stripped Bare By Her Bachelors, Even (The Large Glass)
Yokoyama Taikan’s Metempsychosis
Work by M. C. Escher, Pablo Picasso, Wassily Kandinsky, Max Ernst, and Man Ray
Many 1923 works, like the blockbuster film The Hunchback of Notre Dame, are already in the public domain, as the owners failed to renew their copyrights. Until 1963, a rightsholder had to manually renew their copyright after 28 years.
Advertisement
According to the LibraryLaw Blog, not everything published in 1923 will be public domain; only works with an authorized publication in 1923. The distinction came up in the legal fight over the rights to “Happy Birthday to You,” whose current owners maintained that the song had only been published by unauthorized sources, without the permission of the original owners. (The bad song was eventually ruled public domain for other reasons.) So if you’re worried about litigious rightsholders, make sure the 1923 publication isn’t considered some stolen unauthorized version.
Remember, the works above only lose their copyright on January 1, 2019. Double-check before you use anything listed above, and watch out for all the many ways that works can enter, or not enter, the public domain. Remember that certain uses of copyrighted works are protected as fair use. And check out the many existing collections of already rights-free works, and freely available copyrighted works.
With a rich history that dates back for more than a millennium, the Free State of Saxony (Freistaat Sachsen in German) has a vibrant culture and economy, and has even been called “Silicon Saxony” by microchip producers in the area. Last year, it was also home to the first ever Maker Faire Sachsen, adding to the ever-growing number of Maker Faires in German-speaking regions. The inaugural event showcased 50 maker projects and drew a crowd of 3,500 visitors over the course of the weekend. This year, Maker Faire Sachsen takes place on April 14 and 15, and will showcase even more makers.
What makes Maker Faire Sachsen particularly unique is its location. Rather than being hosted at a fairground or event center, Maker Faire Sachsen takes place at Stadthalle Chemnitz, a notable civic hall built in the early 70s, which creates a special, intimate atmosphere. As noted on the Maker Faire Sachsen site, “For more than 200 years, skilled inventors have come to Chemnitz. The city is a living technology location that reinvents itself time and again. Historic industrial buildings and workers’ houses from the Wilhelminian era line the streets, reminiscent of Germany’s largest manufacturing concentration at the end of the 18th century.” This “reinvention” has made it a fertile environment for the Maker Movement to blossom in.
This year, the show will feature more makers from across Europe, as well as from within the region. Organizing team member Pierre Graupner shares:
“We have more regional companies attending, which is great. We are convinced that enterprises in Saxony, where we have mainly medium-sized machine building companies, are made and run by the maker spirit. For example, one of the local machine-buildersVogel Gruppe,is bringing a machine to bend tubes. At Maker Faire Saxony, children can make coat hooks with it. We love that, as it shows very practical applications that can rise from the maker spirit. This concept also plays out in collaborations. For example, last year, one of our exhibitors met the CEO of a local company who was visiting and now they are developing a product together and will give a talk on that.”
See a full list of exhibiting makers and scheduled presenters, as well as all the information you need to attend, on the Maker Faire Sachsen website. Here are just a small sampling of the diverse projects that will be on display.
One Love Machine Band
The brainchild of native Berlin artist Kolja Kugler, the One Love Machine Band is a robotic band made of reclaimed materials. And in case you’re wondering if junkbots can rock, you can stop wondering because they most certainly do!
Brick’R’Knowledge
Brick’R‘Knowledge is a flexible, expandable electronic system to learn and teach, experiment and develop. The individual bricks are connected via a plug system so you can quickly make even complex circuits. In addition, you can plug the bricks in different angles. Each brick includes two contacts containing ground. Because the system is open source, you can develop your own bricks and create your own experiments. Brick’R’knowledge is ideal for prototyping and can be used in schools, vocational training, and universities.
Circuit Accessories
Leipzig-based designer Roswitha Petersen of Circuit Accessories lovingly repurposes old circuit boards into beautiful new jewelry. With great attention to detail, she selects the individual board sections so that each piece becomes a composition of its own. A coating of synthetic resin protects against oxidation and makes the original colors light up.
Team Fortis Saxonia
Team Fortis Saxonia is comprised of students of various disciplines from Technische Universität Chemnitz (Chemnitz University of Technology), working together to develop a hydrogen-powered prototype vehicle for participation in the Shell Eco-marathon. Two of their current projects are the UrbanSAX, the efficient urban concept vehicle (above), and the Hydrobike, their fuel cell motorcycle “for maximum driving pleasure.”
Variobots
Variobot develops innovative bionic mini-robot kits that use a highly sensitive sensor network that makes them particular sensitive to their environments. These mini-robots can master self-built obstacle courses, push blocks in front of them, or follow an object at a certain distance. All functions can be set directly on the robot in a few simple steps and require no programming. The kits offers children an exciting and playful introduction to the world of electronics.
CoBo Lights
Chemnitz-based artist Franziska Dörner hand-makes unique CoBo Lights lamps from reclaimed materials, such as old radiant heaters, cans, canisters, and bottles. She breathes new life into these discarded materials.
Percona announces the release of Percona Monitoring and Management 1.9.1. PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible.
This release contains bug fixes only and supersedes Percona Monitoring and Management 1.9.0. This release effectively solves the problem in QAN when the Count column actually displayed the number of queries per minute, not per second, as the user would expect. The following screenshot demonstrates the problem. The value of the Countcolumn for the TOTAL row is 649.38 QPS (queries per second). The total number 38.96 k (38960) is only sixty times greater than the reported value of QPS. Thus, queries were counted for each minute within the selected time range of Last1hour.
Query Analytics in PMM version 1.9.0.
The corrected version of QAN in PMM 1.9.1 shows that queries are now counted per second. The total number of queries is 60 * 60 greater than the value of QPS, as should be expected for the chosen time range.
Percona announces the release of Percona Monitoring and Management 1.9.1. PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL and MongoDB performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL and MongoDB servers to ensure that your data works as efficiently as possible.
