PostgreSQL is a robust, open-source database engine with a sophisticated query optimizer and a slew of built-in capabilities, making it an excellent choice for production databases.
Mailshake is an email outreach tool that has features like mail merge and auto follow-ups to make email outreach fast and effective. Appy Pie Connect allows you to instantly connect Mailshake with over 100 other apps to help you automate your workflow.Mailshake Integrations
PostgreSQL + MailshakeUnsubscribe Recipients in Mailshake when New Row is created in PostgreSQL Read More...
PostgreSQL + MailshakeAdd Recipient by Email Address in Mailshake when New Row is created in PostgreSQL Read More...
PostgreSQL + MailshakeAdd Recipients by Email Addresses in Mailshake when New Row is created in PostgreSQL Read More...
PostgreSQL + MailshakePause Unpause Campaign in Mailshake when New Row is created in PostgreSQL Read More...
It's easy to connect PostgreSQL + Mailshake without coding knowledge. Start creating your own business flow.
Triggered when you add a new column.
Triggered when you add a new row.
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
Triggers when a recipient clicks on a link.
Triggers when a lead is created.
Triggers when the status of a lead changes.
Triggers when an email is sent to a recipient from one of the campaign sequence messages.
Triggers when a recipient opens an email.
Triggers when a recipient replies to one of your messages.
Adds a new row.
Updates an existing row.
Adds a single recipient to a campaign. NOTE: This can cause emails to immediately be sent.
Adds multiple recipients to a campaign. NOTE: this can cause emails to be immediately sent
Creates leads from existing recipients that match the given email addresses.
Pauses or unpauses all sending for a campaign. When pausing, emails currently being sent will not be stopped. When unpausing, the sending calendar will be rescheduled to account for any pending emails.
Pauses or unpauses a recipient from receiving pending emails. WARNING: When unpausing, this may cause emails to be sent immediately.
Unsubscribes one or more recipients from all current and future campaigns for your team.
Updates lead status to Won, Lost, Ignored, or Reopened.
PostgreSQL is an object-relational database management system. It provides a full range of data types, operators, and functions, including:
number (integer and floating point)
string (character varying and character constant)
bopean (true or false)
range (date and timestamp)
array (a sequence of values)
geometry (point, line, and box),
arithmetic (addition, subtraction, multiplication, division)
grouping (aggregate, e.g. count(*. )
comparison (equal, not equal)
logical (and, or)
built-in functions that operate on built-in types, e.g., length(. , substring(. , date_part(. , array_length(. , array_to_string(. etc.
user-defined functions created using SQL CREATE FUNCTION command
In addition to these features it supports triggers, stored procedures, views, materialized queries, replication, and more. You can read more about PostgreSQL here.
Mailshake is an open source PHP library for sending transactional emails. Mailshake makes it really easy to send transactional emails. It’s a web service that handles everything from sending emails for you through to setting up your email templates. You can integrate Mailshake into any PHP application. Check out our documentation to learn how you can use Mailshake. In addition to Mailshake’s web-based user interface you can also programmatically send emails via the API or webhooks. You can read more about Mailshake here.
In this section I will explain the integration of the two products. First, I will give a brief introduction of both products. Then I will go over the details of the integration of the two products at the end I will make some conclusions. To start off with I will give a brief introduction to PostgreSQL and Mailshake. PostgreSQL is an object-relational database management system that offers an extended implementation of the SQL language combined with many features found in commercial databases. It is developed by the PostgreSQL Global Development Group, which is made up of a handful of companies and several hundred individuals worldwide who vpunteer their time and effort. On the other hand, Mailshake is an open source PHP library for sending transactional emails. It makes it really easy to send transactional emails. It’s a web service that handles everything from sending emails for you through to setting up your email templates. Now that we know about each product individually lets dive right in to the integration of the two products. First thing is first let’s get the two systems communicating with each other. The first step was was to install PostgreSQL on our machine with composer composer create-project postgres/postgres --prefer-dist . now that PostgreSQL is installed we need to import our tables into PostgreSQL using psql . The next step would be to configure our connection array in our config file. A connection array is used to connect the Mailshake class to our database within our project. Here is an example of how to set up our connection array. After importing our database into PostgreSQL it is time to set up our database tables in Mailshake. First create a new application under settings > applications then click on create new app button on the screen that pops up. After you have clicked on the create new app button it will take you to a page that looks like this if you are viewing on mobile device it will be slightly different but the same idea applies. Click on code tab which should be the third tab on the page. Next select “PHP” as your coding language on top of the page where it says “Coding Language” under “Application Type” if you are using mailshake on mobile device it will look slightly different but you will still find it under Application Type section of your app settings page. Now copy the fplowing code into your app settings section after you have pasted your code into your settings page click save then save again then click on generate sample codes button that is located on top left hand side of your app settings page. Now that our app is set up we need to add our logic bookmarks in order to communicate with out database. This can be done by adding a function in our app settings called “function name” which will be used later in our code.. The only thing left for us to do is add code logic in our code that will query our database and return the data we want so we can display it in our email template! This can be done in various ways such as. 1 - Using a function we created earlier in our app settings 2 - Using a helper function we created earlier in our code 3 - Using custom code we wrote ourselves 4 - Using helper functions from other libraries such as template tags 5 - Using custom helper functions we wrote ourselves 6 - Using third party helper functions such as template tag helpers 7 - Using third party helper functions such as template helpers Now that we have finished integrating PostgreSQL and Mailshake we may want to add additional functionality such as sending emails only when one of our users has logged in and added something in one of our stores and not when they log in and don’t add anything in one of our stores or any other condition we may want to add in order for us to send an email based on certain conditions we must add additional logic for this function in our code just like the login function which we could have done any way we chose from the list above! In addition to all of this we could have made this process automated by adding a cron job to run every minute or every hour depending on how often we want them to run! All of this can be done from Mailshake app settings! We have just completed a fully functional integration between PostgreSQL and Mailshake! As you may have noticed there were a lot of steps invpved but if anyone has ever integrated Mailshake with an external system they have done it! If not they have probably had a pretty hard time doing so! I hope you guys enjoyed this blog post! Make sure you give me a fplow if you haven’t already!
The process to integrate PostgreSQL and Mailshake may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.