Jaxsta Announced Music Credentials API

Featured Imgs 23

Jaxta is an online music credentials resource that was founded in 2015 with the aim of ensuring that music creators get the credit that they are due. The company now operates a massive database of music credits and has announced an API to expose this data for third-party use.

Endless loop in mysql function

Category Image 101

Hello all.
I have a funtion in MYSQL to substruct days from a date.
This function seamsto work but some dates it times out.
This is my function

CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date
    DETERMINISTIC
BEGIN
declare calculated date;
declare added int default  0;

Lbl_Loop: Loop
IF added=intrval then
leave lbl_loop;
End IF;
set calculated = DATE_SUB(req,interval 1 day);
IF weekday(calculated)<5  then
set added= added+1;
End If;
end loop;
RETURN calculated;
END

If I do select Calculater(1,"2020-02-04"); it works, but select Calculater(1,"2020-02-02"); it runs for a few seconds and My SQL times out.

Thanks in advance.

Introduction to positionstack's Forward and Reverse Batch Geocoding REST API

Featured Imgs 23

Welcome to today's tutorial on apilayer's positionstack, a forward and reverse batch geocoding REST API. For those that don't know, forward geocoding translates a street address to GPS coordinates and reverse geocoding converts GPS coordinates to a street address. Batch geocoding allows you to convert a large volume of street addresses to GPS coordinates and vice versa.

The Eclipse Foundation Announces the Sparkplug Working Group

Featured Imgs 23

Today at the ARC Advisory Group’s 24th Annual Industry Forum, the Eclipse Foundation announced the launch of the Sparkplug Working Group, which is driving the evolution and broad adoption of the Eclipse Sparkplug Specification that enables the creation of open, interoperable, Industrial IoT (IIoT) solutions utilizing MQTT.

Convert Blog Posts to Social Media Campaigns with Missinglettr

Fotolia Subscription Monthly 4685447 Xl Stock

missinglettr reviewIn this article we will review Missinglettr – an easy-to-use, fully automated, content repurposing tool for social media. Given that reach of organic social media posts are just around 1-2%, it only makes sense to periodically share your existing content on these platforms. However, re-creating social media posts from the same old content is a […]

The post Convert Blog Posts to Social Media Campaigns with Missinglettr appeared first on WPExplorer.

HTMLHint

Featured Imgs 23

Along with our recent release of using Prettier for code formatting, we've also now upgraded our HTML linter to use HTMLHint instead of html-inspector. Interestingly, they have about the same number of stars on GitHub, but html-inspector is archived and no longer maintained while HTMLHint is actively maintained.

You use it by selecting Analyze HTML from the editors actions menu.

For us, it also meant being able to send off your HTML to our own service, just like we do with all our preprocessors. We weren't doing that with html-inspector as it was meant to be injected into the DOM to run and we had a fancy little process for doing that. It's much better this way for security and consistent handling of code services on our end.

Config

This is for all Pens on the entirely of CodePen, it can't be customized on a per-Pen or per-Account basis. Here's how we have it set up:

{
  'alt-require': true,
  'attr-lowercase': true,
  'attr-no-duplication': true,
  'attr-unsafe-chars': true,
  'attr-value-double-quotes': true,
  'attr-value-not-empty': false,
  'doctype-first': false,
  'doctype-html5': false,
  'empty-tag-not-self-closed': false,
  'head-script-disabled': false,
  'href-abs-or-rel': true,
  'id-class-ad-disabled': false,
  'id-class-value': false,
  'id-unique': true,
  'inline-script-disabled': false,
  'inline-style-disabled': false,
  'space-tab-mixed-disabled': 'space',
  'spec-char-escape': true,
  'src-not-empty': true,
  'style-disabled': false,
  'tag-pair': true,
  'tagname-lowercase': true,
  'title-require': false
}

I post this mostly because we've already had to make some small changes to it after release. For example, we had a value set for id-class-value that is meant to be an opinionated way you should name your ids and classes. That doesn't make sense on CodePen. Y'all can do whatever you like with naming. This is more about finding things in your HTML that are almost certainly a mistake or would cause a problem.

The post HTMLHint appeared first on CodePen Blog.

An Interview With Zach Leatherman: A SmashingConf Austin Speaker

Featured Imgs 23
An Interview With Zach Leatherman: A SmashingConf Austin Speaker

An Interview With Zach Leatherman: A SmashingConf Austin Speaker

Rachel Andrew

We are so excited to be bringing SmashingConf to a new city this year. We’re bringing you SmashingConf Austin and we have a fantastic line-up of speakers.

Check out this post, where we introduce our new venue of Austin and share an interview with Miriam Suzanne. This time we have an interview with Zach Leatherman.

Zach will be talking about type and font performance at SmashingConf Austin. See you there?

Zach is no stranger to the Smashing stage, and if you want to find out more about web fonts and loading strategies, you can watch his talk from SmashingConf London 2018, paired with a talk by Monica Dinculescu from SmashingConf Barcelona, “Web Fonts And Performance: SmashingConf Videos".

Also, take a look at some of the resources that Zach has made available on the subject in his archive of posts about web fonts. There is plenty to get you started, and I think you can agree that there is no-one better to help us understand the current state of font loading while we are in Austin!

Tickets Are On Sale Now!

If you want to join in the fun, tickets are on sale. Last year, we sold out three of our conferences well before the conference date, and popular workshops also fill up fast. Just saying!

Smashing Editorial (il)