If you use atom... download & install the following packages:
Emanuele Ianni invasionofsmallcubes
👻
narainsagar
/ mailchimp_3.0.php
Last active
June 11, 2023 08:59
How to Dynamically send a newsletter with MailChimp 3.0 via PHP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Reference Links: | |
| * - https://mailchimp.com/help/find-your-list-id/ | |
| * - https://stackoverflow.com/a/48655086/5228251 | |
| * - https://thedebuggers.com/send-mailchimp-newsletter-via-php/ | |
| */ | |
| // Include Mailchimp API 3.0 |
tsiege
/ The Technical Interview Cheat Sheet.md
Last active
April 20, 2024 16:52
This is my technical interview cheat sheet. Feel free to fork it or do whatever you want with it. PLEASE let me know if there are any errors or if anything crucial is missing. I will add more links soon.
I have moved this over to the Tech Interview Cheat Sheet Repo and has been expanded and even has code challenges you can run and practice against!
\
rgreenjr
/ postgres_queries_and_commands.sql
Last active
April 23, 2024 19:14
Useful PostgreSQL Queries and Commands
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |