What's the performance of a MySQL LIKE query on a similar sized table (with an index)?
7,240 karma · joined March 8, 2011
https://dave.engineer
Work https://passenger.tech
http://github.com/dave1010 @dave1010 dave1010 at gmail dot com
Senior PHP Engineer
We Are Base
Bournemouth, United Kingdom
Full time, in house
This is a genuine opportunity to work alongside talented people to innovate and build digital services that make a difference to people every day, including an exciting product spin out. Working in an increasingly connected life, the role looks a little something like this:
1st class engineer
You will be used to working as part of an unsilo’d production team, where designers work alongside developers, in agile sprints where they’re useful. Your main skill set is writing PHP but you may have experience with other languages (like JavaScript/Node.js, Go, Objective C or Java) that has influenced how you code. You’ll be familiar with PHP frameworks, such as Symfony, Laravel, Aura & Zend, and building on top of content management systems, such as WordPress. You’ll be comfortable with object orientated design patterns, unit testing, APIs & databases. Every pony at Base is capable of more than one trick. You’ll have an understanding of usability and how that works with functionality
Data hungry
You’ll have a keen interest in datasets, with good skills in filtering the signals from the noise. You’ll have an eye to the future and know that tracking something now will make for way more interesting times later. You’ll be comfortable integrating 3rd party systems through APIs you’ve helped architect.
Open all hours
You’ll have a keen interest in the way openness in technology (and in particular open data) can change things. And you’ll have ideas that mash one set with another, whether you’ve realised them yet or not. Our developers come up with projects for our clients, rarely the other way round.
Solver of riddles
You won’t know the answer to every question that comes your way, but you’ll be someone who knows how to hunt it down. This job isn’t forensic science, but being able to piece the jigsaw back together and crack the nut is your daily bread. Inquisitive by nature you, like us, want to understand what makes things tick to make them better.
Getting shit done
You’ll understand technical debt and be acutely aware that most pieces of code aren’t perfect, but you’ll be good at balancing the need to do something beautifully and the need to do it fast, including both where you can. You’ll regularly use Git, bash scripting and Sass, or similar, because of what they bring to the table.
Commercially aware
You will be able to develop a genuine understanding of our client businesses, allowing you to identify opportunities for and with them. The best developers understand the end goal, not just their role in a project. You’ll be able to think commercially about the client business, as well as deliver work that doesn’t fall over as its user base scales. You’ll be expected to apply innovation to solve challenges, remembering that the best solutions are often beautiful in their simplicity.
Keen eye, tuned ear
An eye for detail and a high standard of output is important to the success of the role. We’ve developed a code standard that gives us a bar to reach for. You’ll play a part in developing and guiding it as we grow. You’ll know that most project budgets don’t allow interface designers to cover every inch of an application, so you’re good at communicating with them and finding ways to smartly join the dots with a minimum of fuss.
Security and speed
You’ll be hot on security too. The one thing that no one sees, until it goes to the wall. Then everyone knows about it. You’ll know how to react when an overseas friend tries to gain access to one of your servers from your years of ethical hacking. Creating applications that are quick is fundamental to the role too. An understanding of devices, connections and optimisation is key to delivering the quality we’re after. But then you already know that.
About We Are Base
We're a digital service design company that builds user-centred digital services for businesses, using data they already have.
We help our clients realise opportunities by transforming their data into something new and valuable. Clients include Timex, Garmin and Nottingham City Transport.
At Base you will be part of a team of makers and doers, working across a variety of projects and clients. We’re agile, but not dogmatic about it. Our process evolves to suit our needs.
We value and support CPD, actively seeking clients with a like-minded desire to push boundaries, providing you with an opportunity to build your experience and skills.
We practice a sustainable pace, recognising that we each have lives and families outside of work. Late nights and > 40 hour weeks are rare by design.
Someone ported Quake 3 to ARMv6 Symbian smartphones in 2008 [0]. I remember running this on a Nokia E90 Communicator and the framerate was over 15fps most of the time.
Senior PHP Engineer
We Are Base
Bournemouth, United Kingdom
Full time, in house
This is a genuine opportunity to work alongside talented people to innovate and build digital services that make a difference to people every day, including an exciting product spin out. Working in an increasingly connected life, the role looks a little something like this:
1st class engineer
You will be used to working as part of an unsilo’d production team, where designers work alongside developers, in agile sprints where they’re useful. Your main skill set is writing PHP but you may have experience with other languages (like JavaScript/Node.js, Go, Objective C or Java) that has influenced how you code. You’ll be familiar with PHP frameworks, such as Symfony, Laravel, Aura & Zend, and building on top of content management systems, such as WordPress. You’ll be comfortable with object orientated design patterns, unit testing, APIs & databases. Every pony at Base is capable of more than one trick. You’ll have an understanding of usability and how that works with functionality
Data hungry
You’ll have a keen interest in datasets, with good skills in filtering the signals from the noise. You’ll have an eye to the future and know that tracking something now will make for way more interesting times later. You’ll be comfortable integrating 3rd party systems through APIs you’ve helped architect.
Open all hours
You’ll have a keen interest in the way openness in technology (and in particular open data) can change things. And you’ll have ideas that mash one set with another, whether you’ve realised them yet or not. Our developers come up with projects for our clients, rarely the other way round.
Solver of riddles
You won’t know the answer to every question that comes your way, but you’ll be someone who knows how to hunt it down. This job isn’t forensic science, but being able to piece the jigsaw back together and crack the nut is your daily bread. Inquisitive by nature you, like us, want to understand what makes things tick to make them better.
Getting shit done
You’ll understand technical debt and be acutely aware that most pieces of code aren’t perfect, but you’ll be good at balancing the need to do something beautifully and the need to do it fast, including both where you can. You’ll regularly use Git, bash scripting and Sass, or similar, because of what they bring to the table.
Commercially aware
You will be able to develop a genuine understanding of our client businesses, allowing you to identify opportunities for and with them. The best developers understand the end goal, not just their role in a project. You’ll be able to think commercially about the client business, as well as deliver work that doesn’t fall over as its user base scales. You’ll be expected to apply innovation to solve challenges, remembering that the best solutions are often beautiful in their simplicity.
Keen eye, tuned ear
An eye for detail and a high standard of output is important to the success of the role. We’ve developed a code standard that gives us a bar to reach for. You’ll play a part in developing and guiding it as we grow. You’ll know that most project budgets don’t allow interface designers to cover every inch of an application, so you’re good at communicating with them and finding ways to smartly join the dots with a minimum of fuss.
Security and speed
You’ll be hot on security too. The one thing that no one sees, until it goes to the wall. Then everyone knows about it. You’ll know how to react when an overseas friend tries to gain access to one of your servers from your years of ethical hacking. Creating applications that are quick is fundamental to the role too. An understanding of devices, connections and optimisation is key to delivering the quality we’re after. But then you already know that.
About We Are Base
We're a digital service design company that builds user-centred digital services for businesses, using data they already have.
We help our clients realise opportunities by transforming their data into something new and valuable. Clients include Timex, Garmin and Nottingham City Transport.
At Base you will be part of a team of makers and doers, working across a variety of projects and clients. We’re agile, but not dogmatic about it. Our process evolves to suit our needs.
We value and support CPD, actively seeking clients with a like-minded desire to push boundaries, providing you with an opportunity to build your experience and skills.
We practice a sustainable pace, recognising that we each have lives and families outside of work. Late nights and > 40 hour weeks are rare by design.
For starters, the incredibly dangerous runkit extension (like importing Objective-C's runtime).
There's also the Reflection API, which provides introspection and is quite widely used.
PHP also has magic methods, such as __call(), which give the ability to handle calling a method that doesn't exist.
As others have mentioned about Objective-C, these are all nice tools to know about and understand, however using them is often a code smell and can lead to unmaintainable code.
PHP doesn't have anything like categories, which is a shame because they look really useful in cases (as long as you don't mind violating the SRP a little). PHP has traits, which are more similar to mixins in ruby than categories in Objective-C.
Oh, PHP also has eval().
PHP's number_format() doesn't escape for HTML - is that an XSS bug too?
Disclaimer: not a RoR developer.
Viewing source in this case seems like it's bypassing DRM, which I believe is illegal under the DMCA in the USA.
As there is so much we don't know yet, it seems crazy to say that creationism absolutely cannot be true, even though it's crazy to say that creationism is true.
strace -f <command> 2>&1 | grep ^open
There's normally other ways to do this (eg using a debugger) but sending strace's stderr to stdout and piping through grep is useful in so many cases it's become a command I use every day or 2.
with AllowOverride 215rps
without AllowOverride 245rps
We're a digital agency, looking for 1 full time senior PHP developer and 1 full time Android/iOS developer. Full details:
What would the result be if you got 2 developers, 1 with 5 years experience building HTML5 apps and 1 with 5 years building native apps, and gave them 3 months to create an apps for Android and iOS?