If you’d like to use a custom SSH config file, open Sequel Ace’s preferences (from the menu bar), go to the “Network” settings tab, and select the SSH config file you would like to use. Sequel Ace runs in a sandboxed mode and by default cannot access your SSH config file. Sequel Ace doesn’t read my ~/.ssh/config parameters. On the server, configure MySQL by editing /etc/my.cnf and comment or remove skip-networking from the section. My SSH connection gives the error: SSH port forwarding failed and MySQL said: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0 I’m having trouble connecting to a MySQL 4 or MySQL 5 database on localhost with a MAMP install. Any suggestions what what we should get to get us started would be great.Socket=/Users/YourUserName/Library/Containers/-ace/Data/mysql.sock Right now we are just developing sites and not looking to develop any themes or add-ons. Is MAMP essentially the same thing as this “Local” program? We also have had a couple clients want WP sites, so I was researching dev tools for that as well and came across and interesting tool that seems to be an all-in-one package called “Local”. Reading through this post and a few others, it looks like there are a lot of tools people use for local dev. Especially since we have a number of clients that are on the legacy C5 platform that we will need to convert over. More recently, we’ve started thinking we should really switch to doing dev on a local system and then uploading to the live when we are ready. Sometimes we would do a subdomain and then transfer the content to the primary…I know, that is probably not the best way to develop websites. So we’ve pretty much always developed websites on a live server and just blocked access until the client was ready. But you can easily install other themes and then customise it with your own CSS. Its problem is that the default theme is arguably quite ugly, so I could imagine many being put off because of that. It’s much more sophisticated than the screenshots suggest. It also works really well with multiple users, with it automatically updating when changes are made by others. Even though there’s just two of us, it’s pretty essential to keep on top of everything. We use it for keeping track of leads, quotes, work on the go, things to invoice, ad-hoc tasks, etc. Kanboard on the other hand we just self host, and is actually surprisingly powerful once up and running, with lots of automated actions. We used to use Jira for a Kanban board, but something about it didn’t quite flow right for us, and we couldn’t justify the on-going cost (even though it’s not expensive). One other tool that I forgot to mention that we use all the time for planning and tracking projects is Kanboard. +1 for the Affinity products, they’re great value. Obsidian looks really interesting, I’m going to check it out. Skitch For annotating screenshots, helps when creating docs or answering support requests.Affinity Designer and Affinity Photo for all our graphic design, site mockups etc.Alfred with powerpack, all sorts of stuff you can do with Alfred, it has a snippet expander which is extremely handy for often used bits of code or letter and email templates, saves a ton of time.Some other less development oriented stuff we use: Obsidian Use it for business planning and also use it to store code snippets, it has full syntax highlighting, and a plugin that gives you one-click copy, very handy.Prepros for compiling SASS minifying and combining JS, we use to use gulp but there are so many moving parts we seemed to spend more time re-writing gulp files than we wanted to, so back to a good ol GUI.Yemuzip for clean zip files, gets rid of Mac detritus.Mac for development, some old Windows laptops for testing.There are lots of other apps we use, but those ones I’d say are critical to the way we work. Codebox - an app to store code snippets, sits in the top bar.It’ll open 100MB text files without skipping a beat. BBEdit - it’s old as rocks, but it’s my little editor I use when I have to open a huge text file, check log file, make some quick notes, etc.1Password - absolutely essential running any kind of business.I’ve ended up using this and it’s worked really well. Archiver - I’ve struggled to find a good zipping program on mac, one that makes it easier to remove hidden files.For times when we only have FTP access, or PHPMyAdmin is broken, this is fantastic. Adminer - a single file mysql admin, similar to PHPMyAdmin.So we do our dev locally, and then push up to dev and live servers when needed. Using Sequel Pro for DB admin, manual backups, etc.Also running MailHog to capture outgoing emails during development.Running an old MAMP copy, for some older databases, but also to run PHP5.6 on a different port.Cross platform too, if I ever need to work from my PC.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |