Category Archive for: MySQL

rfp-robotRFP ROBOT: Website Request for Proposal Generator

The time has come for a new website (or website redesign), which means you need to write a website request for proposal or web RFP. A Google search produces a few examples, but they vary wildly and don’t seem to speak really to your goals for developing or redesigning a new website. You need to write a website RFP that will clearly articulate your needs and generate responses from the best website designers and developers out there. But how?

Have no fear, RFP Robot is here. He will walk you through a step-by-step process to help you work through the details of your project and create a PDF formatted website design RFP that will provide the information vendors need to write an accurate bid. RFP Robot will tell you what info you should include, point out pitfalls, and give examples.


Web Application Developer – OpenEye – Liberty Lake, WA

Java, Spring, MySQL, AWS, Javascript, ReactJS, AngularJS, Memcached, Redis, HTML5, CSS3, Git, Mercurial, Docker, Drupal, PHP….From OpenEye – Sat, 08 Sep 2018 11:30:50 GMT – View all Liberty Lake, WA jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Fast, Good, Local Site Search with Jetpack

If you have, say, 20 posts/pages on your WordPress site, the search functionality that is baked right into your self-hosted WordPress site will probably do a great job. Search is a pretty cool feature to ship with WordPress, truth be told. But as a site grows, you’ll find limits. How it works behind the scenes is a touch over my head, but as I understand it, it does a MySQL LIKE query on your post titles and post content. It tries its best to order by relevance (like if it finds an exact sentence match), then largely orders by date. If search is super important to your site (here on CSS-Tricks, on-site search gets used a ton) you’ll probably look for other options. TLDR: Jetpack Search is quite good out of the box, customizable, and requires very little effort. A quick jaunt through a decade-long journey. I started with Google…

Read More →

Consultant Drupal Developer, Digital Health – PATH – Seattle, WA

The OPP is built in the coding language Drupal. Demonstrated experience with Drupal, PHP, Perl, MySQL, PostgreSQL, relational database design, web application…From PATH – Thu, 07 Jun 2018 05:37:43 GMT – View all Seattle, WA jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Five of My Favorite Features of Jetpack

Jetpack is an official WordPress plugin directly from Automattic. It’s an interesting plugin in that it doesn’t just do *one thing* — it does a whole slew of things that enhance what your WordPress site can do. *Any* WordPress site, that is, and often with extremely little effort. Those easy win features Jesse Friedman calls light switch features, meaning you literally flip a switch in Jetpack’s settings and start benefitting. I love that. There are dozens of features in Jetpack, and I personally make use of most of them and see the benefit in all of them. Allow me to share with you five of my favorites and how they are actively used right here on this site. It’s actually a bit hard to pick, so perhaps I’ll do this again sometime! 1) Related Posts This seems like such a simple little feature, but it’s anything but. Something has to…

Read More →

Web Designer and Developer – OpenEye – Liberty Lake, WA

Experience with Drupal Content Management System. OpenEye is looking for an experienced web developer. Docker, Drupal, PHP, Java, MySQL, Javascript, Nodejs,…From OpenEye – Fri, 11 May 2018 02:49:30 GMT – View all Liberty Lake, WA jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Conceptual compression means beginners don’t need to know SQL — hallelujah!

It used to be a fundamental requirement that you learned an extensive amount of SQL before you were able to start working on database-backed applications. It was taken as self-evident that you needed to speak the native language of the database before you were qualified to use it. And better yet, you really ought to understand and care about your particular brand of database engine.This is no longer so. That fact has snuck up upon us, but it’s none the less true — and that’s amazing.Through advances in leaky abstractions, we’ve managed to compress the conceptual overhead of the database so much that it needn’t feature in the introduction material for making database-backed applications. In Rails, we call that abstraction Active Record, and it falls into the category of object-relational mappers (ORM).The ORM was long derided by programmers as an unreliable, even harmful, aid of the lazy or the weak. Something Real Programmers shouldn’t expect…

Read More →

Kinsta

(This is a sponsored post.)Huge thanks to Kinsta for sponsoring CSS-Tricks this week! We’re big fans of WordPress around here, and know some of you out there are too. So this might come of interest: Kinsta is WordPress hosting that runs on Google Cloud Platform. And in fact, it’s officially recommended by Google Cloud for fully-managed WordPress hosting. What does that matter? Well, when you go with a cloud host you’re entering a new realm of reliability. For example, your site is run in its own isolated container, including all the software required to run it. Familiar stuff like PHP, MySQL, and Nginx. Those resources are 100% private and not shared between anyone else – not even other sites of yours. Spinning up a site is incredibly easy from their nice dashboard You aren’t on your own here. Yes, you’re using powerful low-level infrastructure from Google Cloud Platform, but you…

Read More →

Kinsta

(This is a sponsored post.)Huge thanks to Kinsta for sponsoring CSS-Tricks this week! We’re big fans of WordPress around here, and know some of you out there are too. So this might come of interest: Kinsta is WordPress hosting that runs on Google Cloud Platform. And in fact, it’s officially recommended by Google Cloud for fully-managed WordPress hosting. What does that matter? Well, when you go with a cloud host you’re entering a new realm of reliability. For example, your site is run in its own isolated container, including all the software required to run it. Familiar stuff like PHP, MySQL, and Nginx. Those resources are 100% private and not shared between anyone else – not even other sites of yours. Spinning up a site is incredibly easy from their nice dashboard You aren’t on your own here. Yes, you’re using powerful low-level infrastructure from Google Cloud Platform, but you…

Read More →

SANDcamp: Introduction to Site Building

Start:  2018-03-23 09:00 – 17:00 America/Los_Angeles Organizers:  rainbreaw cstauffer Event type:  Training (free or commercial) https://www.sandcamp.org/introduction-drupal-8-site-building Description Learn the basics of building a CMS (content management system) based website using Drupal 8 — a completely customizable, flexible, and scalable open-source framework. This introduction will give you all of the essentials required to produce a straightforward site, customize your content and displays, and enough knowledge to find more targeted information for unique customizations as you progress through your Drupal site building adventures. This training is being offered by STAUFFER – www.stauffer.com – for free as part of the Drupal Global Training Days initiative. Training Agenda Morning: Part I Introduction: What is Drupal? Getting Set Up Quickly Basic Site Configuration Basic Content Creation Navigation / Structure: — The Menu System — Taxonomy Morning: Part II Going beyond OOTB (out of the box) Options — Changing functionality with Contributed Modules — Customizing your…

Read More →

Essential Web Technologies to Learn (2018 Edition)

Becoming a web developer is easy, so they say. What most people feeding you that line neglect to mention is that while almost anyone can be a web developer, not everyone using that title is good at web development. All of us must make a start somewhere, and if you’re just getting started in your web developer career, this article is for you. It is also an article for seasoned web developers who may not have kept up with the latest essential skill sets and want to discover what they are for 2018. 1. HTML This is the most obvious essential skill that any web developer needs to know. At the least, you’ll need to be an expert in HTML5. HTML is the “language of the web”, and it’s what all sites are built in, even sites that aren’t built in it. What does that mean? It means sites that…

Read More →

Web Developer (Internet Developer II) – World Vision Inc. – Federal Way, WA

WordPress, Drupal , PHP, MySQL, and Git. World Vision is looking for a Web Developer. Additionally, support team developers have the option of a more…From World Vision Inc. – Sat, 20 Jan 2018 06:33:45 GMT – View all Federal Way, WA jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

The WordPress Explained Book is Coming Soon

Do you need to build a WordPress site?  If you can wait a few weeks, the “WordPress Explained” book is coming to your rescue. This book will teach everything you need to know to make a WordPress site. And, it will do it in plain English, with a simple step-by-step approach. This book forms part of a web design library. Drupal 8 Explained, Joomla 3 Explained, and MySQL Explained are already available. Magento 2 Explained and WooCommerce Explained are scheduled for publication this year. Look for even more OSTraining books in 2018! [[ This is a content summary only. Visit http://OSTraining.com for full links, other content, and more! ]] Source: https://www.ostraining.com/

DrupalCAP Workshop at Thakur College of Science and Commerce, Mumbai

Start:  2017-09-09 10:00 – 17:00 Asia/Kolkata Organizers:  kajalkiran Nitesh Sethia ashishdalvi Event type:  Training (free or commercial) DrupalCAP team along with Pune and Mumbai Drupal Community announces Drupal 8 Workshop for students on 9th September, 2017. The basic agenda of this Global Training Day is to give a walk through and hands-on experience on Drupal and Site building to students of Thakur College of Science and Commerce. Following are the details of the workshop : DATE : 9th September 2017 TIME : 10 A.M – 5 P.M. VENUE : Thakur Village,Kandivali (E), Mumbai – 400 101 Tel: 2887 06 27, 28462565 Fax: 2886 8822 Below informations will help you configure your system for using Drupal. System requirements: 1. Running Local Server : Download and Install MAMP/XAMPP/LAMP on your system. Windows User: XAMPP would be preferred (Faster and Easier) Install XAMPP for Windows Linux User: LAMP would be preferred. Run following…

Read More →

Magento 2 Explained is Coming Soon

Do you need to build an eCommerce site with Magento?  Today, we’re delighted to say that “Magento 2 Explained” is coming soon. This book will teach everything you need to know to make a Magento 2 site.  Magento has a reputation for being a complex platform, but we’ve successfully explained similar software before with Drupal, Joomla and MySQL. This book will be a fun and straightforward beginners guide to Magento 2. [[ This is a content summary only. Visit http://OSTraining.com for full links, other content, and more! ]] Source: https://www.ostraining.com/

Drupal Developer (PHP/MYSQL) – etouch – Mountain View, CA

Drupal PHP MySQL. Developed in-depth custom modules for Drupal 7, and should be familiar with its ORM, APIs, etc….From etouch – Tue, 08 Aug 2017 08:31:09 GMT – View all Mountain View, CA jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Building a Simple API with Amazon Lambda and Zappa

We recently had a client come to us with a request for a simple serverless API. They wanted little to no administrative overhead, so we went with the AWS Lambda service. It was my first foray with Lambda, and getting it set up came with its fair share of headaches. If you’re starting down the same path and want to build a simple API with Lambda, here’s a tutorial to help. Github If you would rather go through the tutorial on github, you can find it here AWS Lambda This is a great service offered by AWS that allows users to run a serverless application or function. It’s a cloud-based, serverless architecture that comes with continuous scaling out of the box. Deploy your code, and AWS does the rest. It will only run when “triggered,” either by another AWS service, or an HTTP call. It’s relatively young and has room…

Read More →

Acquia Dev Scan: Taming Expanding Databases in Drupal 8, Reservoir on DrupalEasy, and a Conference for Decoupled Drupal Developers

When Acquia-related developer content starts piling up around the Web, it’s time for an Acquia Dev Scan. In this edition: Taming Expanding Databases in Drupal 8, Reservoir on DrupalEasy, and a Conference for Decoupled Drupal Developers Dealing with expanding cache_render tables in Drupal 8 There are a number of scenarios in Drupal 8 where you might notice your MySQL database size starts growing incredibly fast, even if you’re not adding any content. Jeff Geerling, Senior Technical Architect, Acquia, figured out that most of the time the problem stems from a exponentially-increasing-in-size cache_render table. After talking about this problem with a number of colleagues, he decided to write a blog post to cover common scenarios, as well as short and long-term fixes if you run into this issue. Hence: Dealing with Drupal 8 and a giant cache_render table. The DrupalEasy podcast focuses on Reservoir Ebullient DrupalEasy podcast host Mike Anello spent…

Read More →

Local by Flywheel

I’ve switched all my local WordPress development over to Local by Flywheel. I heard about it from y’all when we did a poll not to long ago about local WordPress development. Bottom line: it’s really good. It does everything you want it to, well, with zero hassle, and nothing more. Running Multiple WordPress Installs (PHP, MySQL, Web Server) That’s kind of the whole point. Local by Flywheel spins up a local site for you with all the dependencies that WordPress needs. Just by picking a few options and giving the site a name, you’ve spun up a new WordPress install in a few seconds. And it’s ready to go! Nice UI Surely what Local by Flywheel is doing under the hood is quite complicated, but the UI for the app isn’t at all. I’m a big fan of apps like this. The super clean UI makes everything feel so easy…

Read More →

Back to Top