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.


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 →

The Tenth Fourth

We made it a decade! It’s our tenth birthday! 🎉 This is an extra-special one, as we hit those double digits. Each year on July 4th we mark the occasion with a post. In that tradition, allow me to ramble on a bit about the past and present. The very first post ever on this site was literally a CSS trick. It’s a classic, too. “Header Text Image Replacement”: .headerReplacement { text-indent: -9999px; width: 600px; height: 100px; background: url(/path/to/your/image.jpg) #cccccc no-repeat; } Funny, I just used that trick a couple of days ago. The post is interesting to me for a number of reasons. For one, I certainly didn’t come up with that technique. At the time, I was just learning CSS myself and writing down interesting stuff I’d come across and used in my own work. I think I felt like I learned it a little more deeply by…

Read More →

Web Developer – Princeton University – Princeton, NJ

MySQL, Roxen CMS, Drupal CMS, WordPress. WDS is highly collaborative, with close working relationships between developers, designers, managers, and service…From Princeton University – Sat, 01 Jul 2017 00:29:34 GMT – View all Princeton, NJ jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Web Site Engineer – BLH Technologies, Inc. – Rockville, MD

Development/design experience using Drupal, JBoss, REST, Python and MYSQL. Work with team of developers and engineers in building scripts for continuous…From BLH Technologies, Inc. – Wed, 28 Jun 2017 09:52:52 GMT – View all Rockville, MD jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Percona Live 2017 Blog Post: ProxySQL as a Failover Option for Drupal

One of the more interesting products to hit the spotlight at this year’s Percona Live Open Source Database conference was ProxySQL. This open source MySQL proxy server has been around for a couple of years now and keeps adding more features. The current release (1.3.6) has the usual features that you would expect from a proxy server, like load balancing and failover support, but ProxySQL also has database specific features like a query cache and query routing. The query cache is a scaling feature that serves data at the proxy layer to avoid contacting the database at all. This feature has become very relevant now that Oracle has announced that they’re most likely going to remove the query cache from MySQL in MySQL 8.0. Query routing can map query types to specific servers for very specific forms of load-balancing and read/write splitting. Other interesting of features of ProxySQL that are…

Read More →

ProxySQL as a Failover Option for Drupal – A Report from Percona Live 2017

One of the more interesting products to hit the spotlight at this year’s Percona Live Open Source Database conference was ProxySQL. This open source MySQL proxy server has been around for a couple of years now and keeps adding more features. The current release (1.3.6) has the usual features that you would expect from a proxy server, like load balancing and failover support, but ProxySQL also has database specific features like a query cache and query routing. The query cache is a scaling feature that serves data at the proxy layer to avoid contacting the database at all. This feature has become very relevant now that Oracle has announced that they’re most likely going to remove the query cache from MySQL in MySQL 8.0. Query routing can map query types to specific servers for very specific forms of load-balancing and read/write splitting. Other interesting of features of ProxySQL that are…

Read More →

Drupal 8 Back-end Developer (REMOTE, IMMEDIATE START) – With Pulp – New York, NY

Looking for a back-end Drupal 8 developer proficient with PHP and MySql. Ideally would have experience with Acquia and/or vagrant installation…. $55 an hourFrom Indeed – Wed, 24 May 2017 17:09:51 GMT – View all New York, NY jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Poll Results: Local WordPress Development

We kicked a poll off three months ago asking y’all what kind of local development environment you set up for running WordPress locally. At the time of this writing, we got 2,623 votes, so a decent amount of significance here. Especially because the question was phrased: If you’re running WordPress locally (i.e running PHP, MySQL, and a web server), how are you doing it? Presupposes that you are running a local environment. (Please do that.) Here’s an image of the results: (If you can’t see that, don’t worry, we’re about to go through the results.) The winner, at 61%, was using some kind of software-with-a-UI to manage it. WAMP / MAMP / AMPPS were mentioned, but it also said “Similar software with UI”, which I think is relevant as we’ll see in a second. This option was more than 3 times more popular than any other choice. Vagrant was in…

Read More →

Senior LAMP Developer – Dantech Corporation – Washington, DC

Drupal 7.0+ programming:. 5+ years of experience with Drupal 7.0+ programming. You must have expertise in Drupal 7.0, PHP, Red Hat and MySQL…. $95 an hourFrom Indeed – Tue, 09 May 2017 20:06:59 GMT – View all Washington jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

How to Export Your Joomla! Database with phpMyAdmin

I had request from a reader to provide more detailed instructions on “database wrangling” with your Joomla! database. This article is an attempt at honoring that request. I will add an article later that explains how to import your Joomla! database using phpMyAdmin. To perform the tasks in this article, you will need phpMyAdmin installed on your server. I am using version 4.4.13 of phpMyAdmin and version 5.6.31 of MySQL. For the sake of brevity, I have assumed that you have access to your MySQL server and left out details on how to gain that access. If you are unsure about how to gain access to your MySQL server, you should contact your hosting provider. [[ This is a content summary only. Visit http://OSTraining.com for full links, other content, and more! ]] Source: https://www.ostraining.com/

Fabrica Dev Kit

Fabrica Dev Kit is a toolkit for WordPress development. You… Clone a GitHub Repo Configure your WordPress project (settings, plugins, etc) through a `.yml` file Run a Ruby setup script which Downloads dev dependencies (like Gulp) through npm or yarn Builds a Docker container and volumes to run everything inside of Everything, including the big WordPress dependencies like PHP and MySQL, and running inside Docker. The web server is Nginx and PHP-FPM It goes a step further and sets up some WordPress theme development dev dependencies like: Twig templating Specifically Timber, which brings Twig to a WordPress context and allows for MVC like structuring of your theme Advanced Custom Fields and a customization of that to allow version controlling of that setup It goes another step in sets up build processes for theme development, like: Preprocessing of HTML through PostHTML, so you can use a special BEM syntax PostCSS with…

Read More →

Acquia Cloud CD Launches Today

Today Acquia is pleased to announce the release of Acquia Cloud CD. Acquia Cloud CD is a new service for development process and devops automation which makes life easier for teams working on the Acquia Cloud Platform. It’s an evolution of our developer tools which we believe will help to accelerate code delivery and make life easier and more productive for teams. What is Continuous Delivery? If you’ve read my previous blog post, you’ll recall I talked about the benefits of making small, frequent releases. Smaller releases carry less risk, and by getting new features in front of your customers sooner you can take their feedback and pivot your development priorities accordingly. A regular cadence of releases makes it easier to predict when promised new features will be available, meeting your release date commitments. In effect, you cut down the time spent deploying and move that effort to development. An…

Read More →

Drupal Developer – FAAZ Consulting LLC – Washington, DC

Excellent knowledge of WordPress, Drupal, PHP, MySQL, CSS, HTML and jQuery. Experience coding responsive WordPress themes based on the genesis framework….From Indeed – Tue, 28 Mar 2017 14:39:32 GMT – View all Washington jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Associate Director, Software Development & Project Management – Columbia University – New York, NY

Django, NodeJS, AWS, Hugo, MySQL, RSS, Ajax, Drupal, Linux administration, Apache Administration. The Associate Director will also design and engineer software…From Columbia University – Thu, 16 Mar 2017 22:44:59 GMT – View all New York jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

Web Developer – Institute for Integrative Nutrition – New York, NY

PHP, Drupal, MySQL, JavaScript, (jQuery/Angular/React, Node.js a plus). The Institute for Integrative Nutrition is seeking a Full-Stack Developer to join an…From Institute for Integrative Nutrition – Wed, 08 Mar 2017 14:53:35 GMT – View all New York jobs Source: http://rss.indeed.com/rss?q=Drupal+Developer

PHP For Beginners: Building a Simple CRM from Scratch

Customer Relationship Management (CRM) is a system that manages customer interactions and data throughout the customer lifecycle between the customer and the company across different channels. In this tutorial, we are going to build a custom CRM in PHP, which a sales team can use to track customers through the entire sales cycle. We’ll be creating a simple CRM system for salespeople to: Access their tasks View their leads Create new tasks for each lead Create new opportunity Lose a sale Sales managers will be able to: Manage all customers Manage sales team View current sales activities Download Demo Files Building Blocks of a CRM Here is a list of the essential components of the CRM: Leads: initial contacts Accounts: Information about the companies you do business with Contact: Information about the people you know and work with. Usually, one account has many contacts Opportunities: Qualified leads Activities: Tasks, meetings,…

Read More →

Just starting out? Ditch the “full stack developer” label

The words you use to represent yourself matter — and those words mean nothing.The only time “full stack” means something. 😍The vagueness and confusion around the phrase “full stack developer” has been lingering for years. Google it and you’ll find plenty of discussion about why it’s such a loaded term.Given that long-standing vagueness, labelling yourself as “full stack” might be doing you more harm than good, especially if you’re just starting out.🥞 Are you being honest?“Full stack” basically implies that you can do it all — that you can build front to back effectively and ship.But can you really do all of that well?Anyone with some programming experience can learn the basics of something new and cobble a solution together. But that certainly doesn’t make it good software — a goal every good, experienced programmer strives for.When someone with a few years experience labels themselves as a “full stack developer”, I’m pretty skeptical. Is there really enough experience there to be good at…

Read More →

Back to Top