I have just created a GitHub repository called sql_games. It contains games implemented as stored procedures, that can run on MariaDB or (with some changes) on Percona Server or Oracle MySQL.
You play the games via the command-line client. You call a procedure to make your move, then a text or an ASCII image appears.
Of course the same call should produce a different effect, depending on the game’s current state. To remember the state I use both user variables and temporary tables.
Why did I do that? Mainly because it was funny. I can’t explain why. And I can’t tell that it is funny for anyone: perhaps, where I’ve found interesting challenges, someone else would find a cause a frustration. But yes, it has been funny for me.
Also, I did it because I could. This means that others can do it. Stored procedures are not a useless and nasty feature that users should ignore – they are useful tools. Yes, several times I’ve complained that they need important improvements. But I complain because I like them.
Currently, three games are implemented:
Anagram – The anagram game. See a randomly generated anagram and try to guess the word. You can choose a language, and a min/max word length.
Bulls And Cows – If you don’t know the game, take a look at the Wikipedia page.
Hangman – Try to guess letters and see an ASCII hangman materializing slowly while you fail.
Each game will be installed in a different database. CALL help() in the proper database to see how to play.
via Planet MySQL
SQL Games
The New X-Files Featurette Reveals New Monsters
As a teaser for the X-Files revival, which premieres January 24, Fox has put a 21-minute featurette online called “Re-Opened” which gives a primer on the original series for new viewers and a tantalizing look at the six new episodes for the old fans.
Not everything is new. For example, we knew that the first and last episodes of the revival are mythology episodes and the middle four are standalone episodes. Although we now know that the reason both episode one and six are called “My Struggle” is because the first one is about Mulder’s struggle and the last about Scully’s. We also hear that they play with the original mythology for the show and will explain how the Cigarette Smoking Man could appear in the revival after what looked like his demise at the end of the original run.
There’s a ton of new footage in this. Four people on fire, Mulder flung down a hallway, a teary Scully promising to be by Mulder’s side, a description of a horned beast attack, a lizard creature running away from the FBI… there’s a lot here.
Contact the author at katharine@io9.com.
Worst Wi-Fi Password Ever
(PG-13: Language) Like stories, passwords should be shown, not told. The RocketJump office descends into chaos because the rest of them can’t figure out the Wi-Fi password. Can you guess what it is before the video ends?
via The Awesomer
Worst Wi-Fi Password Ever
Darth Santa
"The holidays have never known the power of the dark side…until now."
This is brought to you by Corridor Digital, the folks behind the "Superman with a GoPro" video.
Merry Christmas and Happy Holidays, everyone!
Make a Bacon and Egg Bread Wreath for a Great Holiday (or Anytime) Breakfast
It’s bacon and eggs stuffed into buttery bread. It cooks in under 15 minutes. It’s shaped like a wreath and can feed eight people. What more can you ask for in a breakfast treat?
Crescent rolls are the MVP of this dish, which you can assemble the night before for a quick bake in the morning. (You do need to have scrambled eggs and cooked bacon before you toss this in the oven.) Perfect for post-holiday mornings when the kitchen is the last place you want to be but you do want a hot dish to serve your whole family. I’m going to stock up on crescent rolls for this and mini apple pie bites all year round.
Bacon and Egg Bread Wreath | YouTube
via Lifehacker
Make a Bacon and Egg Bread Wreath for a Great Holiday (or Anytime) Breakfast
Buying A Gun? Here Is My Advice
Buying a gun for the first time can be frustrating. We cut through a lot of the confusion and stick to what works. This is not a complicated process as some would have you think. […]
The post Buying A Gun? Here Is My Advice appeared first on Bearing Arms.
TFBTV: USMC Rifle Range Qualification
On this episode of TFBTV, Miles Vining takes a look at how the U.S. Marine Corps goes about the annual rifle qualification process that every Marine undertakes every year. Qualification is not only important for keeping up the fundamentals of marksmanship, but also plays into a Marine’s cutting score, or a number that is calculated, […]
The post TFBTV: USMC Rifle Range Qualification appeared first on The Firearm Blog.
If You’re Launching A Tech Startup In 2016, Focus On Privacy And Fast Data
Enterprises over the last decade have devoted large portions of their IT budgets to collecting, securing and analyzing huge volumes of big data. Or at least trying to. But heading into 2016, the increasing complexity of networks, and the sheer number of connected devices that are constantly streaming data over those networks, will create a paradigm shift in how enterprises secure and manage… Read More
via TechCrunch
If You’re Launching A Tech Startup In 2016, Focus On Privacy And Fast Data
The Onion Reviews The Force Awakens
(PG-13: Language) For The Onion, film critic Peter Rosenthal, Star Wars: The Force Awakens will never be as good as the first movie in the series. But he knows that for many horny teens, it – and heck, potentially any movie – will be their best movie ever.
via The Awesomer
The Onion Reviews The Force Awakens
Today’s Best Deals: Apple TV, Virtual Reality, Mini Jambox, and More
Apple’s new set top box, a cheap VR headset, and the smallest Jambox highlight today’s best deals. Commerce Content is independent of Editorial and Advertising, and if you buy something through our posts, we may get a small share of the sale. Click here to learn more.
For a limited time, RadioShack (that’s not a typo) is selling a new Apple TV for $120, or $30 off its MSRP. They’ll also toss an HDMI cable in for good measure. Be sure to check out Gizmodo’s review if you’re on the fence. [Apple TV Next Generation – 32GB and HDMI Cable Bundle, $120]
You have no shortage of options when it comes to Bluetooth speakers, but the Jawbone Jambox line started the entire trend, and its highly-rated mini model is just $60 today on Amazon. [MINI JAMBOX by Jawbone Wireless Bluetooth Speaker, $60]
It’s not as advanced as a Samsung Gear VR or Oculus Rift, but if you have a smartphone and $19, you can experience VR with this View-Master VR starter set.
The View-Master is actually just a Google Cardboard-compatible VR headset, except, you know, it’s not made of cardboard. That means it’s cheap, but not too janky to give as a gift this holiday season. [Viewmaster VR With Google Cardboard Support, $19]
We can all afford to be paranoid at this price. [Magicfly Stainless Steel RFID Blocking Credit Card Holder, $3 with code QNY3U45R]
If your car is old enough to lack both Bluetooth and an AUX jack, this wireless FM transmitter will bring it up to code, no wires required. [Mpow Streambot Flex 2-In-1 Wireless Car Stereo Bluetooth FM Transmitter, $25 with code SJGSYZHL]
I dare say, even a footman could afford to buy the first five seasons of Downton Abbey on Blu-ray for $45. [Preorder Masterpiece Classic: Downton Abbey: Seasons 1-5, $45]
Amazon just kicked off their end-of-year digital game sale, with big discounts on downloadable PC, PS4, and Xbox One titles. Highlights include Cities: Skylines for $12, Bioshock Triple Pack for $14, and Civilization V Complete for $13, but be sure to head over to Amazon to see all of the available discounts. [Amazon]
Adobe’s Photoshop and Lightroom Creative Cloud photography suite normally costs $10 per month, but Amazon’s currently selling a 12-month plan for just $8 per month for the holidays. Creative Cloud plans don’t go on sale often, so if you’re a creative professional, or just want to make your own photos look better, this is a great opportunity to save on industry standard software. [Adobe Creative Cloud Photography Plan, $8 per month for one year]
In just a few short years, App Santa has become one of my favorite holiday traditions, and it’s back today with great deals on popular iOS and Mac apps from some of the best indie developers in the business.
Personally, I use Tweetbot for Mac every single day, and Soulver, Drafts, Clear, and Deliveries also occupy space on my first two iPhone home screens. Every app in the promotion is popular and highly-rated though, so be sure to check out the full list below.
- Soulver – the notepad calculator ($1) | Normally $5
- Terminology 3 – Extensible Dictionary and Thesaurus ($1) | Normally $3
- Drafts 4 – Quickly Capture Notes, Share Anywhere! ($5) | Normally $10
- Clear – Tasks, Reminders & To-Do Lists ($2) | Normally $5
- Perfect Weather – NOAA Radar, Forecast, and Severe Weather Alerts ($1) | Normally $3
- Deliveries: a package tracker ($3) | Normally $5
- Screens VNC – Remote Access To Your Desktop Computer ($14) | Normally $20
- Calendars 5 – Event and Task Manager with Google Calendar Sync ($3) | Normally $7
- Pennies – Personal Money, Budget & Finance Manager ($2) | Normally $4
- PCalc – The Best Calculator ($7) | Normally $10
- PDF Expert 5 – Fill forms, annotate PDFs, sign documents ($5) | Normally $10
- Star Walk™ HD – Guide to the Night Sky Map ($1) | Normally $3
- Vee for Video ($2) | Normally $5
- Group Text+ ($1) | Normally $4
- Launch Center Pro – Shortcut launcher and Today widget ($2) | Normally $5
- Scanner Pro – Scan any document and receipt to PDF ($1) | Normally $7
- Day One (Journal / Notes / Diary) ($1) | Normally $5
- Tweetbot for Mac ($7) | Normally $10
If you’ve got some cash to spend, and need a whopper of a last minute gift, Logitech’s Harmony Ultimate remote is marked down to just $195 today on Amazon, which is an all-time low, and more than $100 off its usual price. [Logitech Harmony Ultimate Remote with Customizable Touch Screen and Closed Cabinet RF Control, $195]
Order today, and you can still stuff everyone’s stockings with sub-$20 Bluetooth headphones. [Mpow Wolverine Bluetooth 4.1 Wireless Sports Headphones, $18 with code NXZ7GIVS]
More Deals
Tech
- PNY Elite Performance 256GB High Speed SDXC Card ($71) | Amazon
- Samsung 64GB EVO Class 10 Micro SDXC Memory Card with Adapter ($18) | Amazon
- Samsung 32GB EVO Class 10 Micro SDHC up to 48MB/s with Adapter ($10) | Amazon
- Yubi Power Slim Surge Protector With 3 AC Plug Outlet Plus 2 USB Ports ($9) | Amazon
- Audio-Technica ATH-M40x Pro Monitor Headphones Black W/Blue Mic YETI USB Mic ($130) | Adorama
- Apple TV Next Generation – 32GB and HDMI Cable Bundle ($120) | RadioShack
- MINI JAMBOX by Jawbone Wireless Bluetooth Speaker ($60) | Amazon
- Sennheiser HD 218i On-Ear Stereo Headphones ($30) | Woot
- iLive Boombox Bluetooth Speaker with CD Player ($37) | Amazon
- Hisense 50-Inch 1080p 120Hz Class LED Smart HDTV ($350) | Walmart
- Dell Inspiron Intel Celeron, 2GB, 32GB eMMC, 14” Laptop ($150) | Best Buy
- HP Pavilion Intel Core i5, 4GB, 1TB, 17.3” Laptop ($350) | Best Buy
- Samsung Ultra-Slim Black Optical Drive, M-Disc Support, MAC OS X compatible ($18) | Amazon
- Huawei Nexus 6P 4G with 32GB Memory Cell Phone ($450) | Best Buy
- View-Master Virtual Reality Starter Pack ($19) | Amazon
- Jumbl 22MP All-In-1 Film & Slide Scanner w/ Speed-Load Adapters for 35mm Negative & Slides, 110, 126, & Super 8 Films ($75) | Amazon
- Inateck iPad Mini Smart Case with Magnetic Auto Sleep Wake-up Function ($7) | Amazon | Use code WUSBA6HW
- ORICO 2.5’’ Aluminum Tool Free Type C USB 3.0 to SATA III Hard Drive Enclosure ($16) | Amazon | Use code BEDALRNI
Home
- Select Solar Gear is On Sale Today at Home Depot
- 4’ 250 Watt Equivalent LED Shop Light ($45) | Woot
- Sunbeam Sunbeam 0.7-Cubic Foot Microwave Oven ($70) | Sears
- Keurig K10 Mini Plus Brewing System ($65) | Amazon
- IRON HORSE Warrior 3.1 26” Mountain Bike ($330) | Sears
- Folding Banquet Table ($30) | Target
- Outdoor Products Arrowhead Technical Pack ($21) | Amazon
- Gerber Gator Machete JR ($11) | Amazon
- GEKO E100 1080p Dash Camera with DVR ($50) | B&H
- GearWrench GearWrench KDT 80066SS 20 Pc. Master Screwdriver Set with FREE 4 Pc. Scraper Set ($101) | Sears
- Magicfly Stainless Steel RFID Blocking Credit Card Holder ($3) | Amazon | Use code QNY3U45R
- Kohree 16 Super Bright LED Wireless Solar Powered Motion Sensor Light ($12) | Amazon | Use code 7KJHJ585
- Kohree Battery-Operated Stick-On LED Tap Light ($7) | Amazon | Use code RSFFQIGC
- Kohree 3 PCS Solar Powered Wireless 4 LED Security Motion Sensor Light ($26) | Amazon | Use code V5FZ2FRF
- Mpow Streambot Flex 2-In-1 Wireless Car Stereo Bluetooth FM Transmitter ($25) | Amazon | Use code SJGSYZHL
- 3-Pack Etekcity Programmable Wireless Remote Control Electrical Outlet Light Switch ($14) | Amazon | Use code W2REMOTE
- Edge Pro 2 Stage Sharpening System Kit Blade Knife Sharpener for Kitchen Chefs ($6) | amazon | Use code SLPXQOFF
Gaming
- Mad Catz M.O.J.O. Micro-Console for Android 16GB ($75) | Amazon
- Refurb / Preowned Xbox One 500GB System, Playstation 4 500GB System, and a Nintendo Wii U 32GB System ($570) | Gamestop
- The Amazon Winter Game Sale is Happeneing Now, Includes Some Console Games
- The Steam Winter Game Sale is Happeneing Now
- Call of Duty: Black Ops III ($30-$40) | Best Buy
- FIFA 16 ($30) | Best Buy
Media
- Best Buy has a Selection of Blu-Rays On Sale Today
- Captain Phillips ($7) | Amazon
- Masterpiece Classic: Downton Abbey: Seasons 1-5 ($40-$45) | Amazon
- Southern Bastards Hardcover Vol. 01 ($20) | Tfaw
- Star Wars, Classic (Ultimate Sticker Books) ($4) | Amazon
- Debbie Macomber’s Cedar Cove Series Vol 1 [Kindle] ($3) | Amazon
- The Woodcutter, Kate Danley [Kindle] ($2) | Amazon
Commerce Content is independent of Editorial and Advertising, and if you buy something through our posts, we may get a smallClick here to learn more. We want your feedback.Send deal submissions to Deals@Gawker and all other inquiries to Shane@Gawker
httpsDeals/status/630717684355694593
via Lifehacker
Today’s Best Deals: Apple TV, Virtual Reality, Mini Jambox, and More