Databases
StackOverflow2013
Usersdbo
USLuke Cousins
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USLuke Cousins
    primarykey
    data
    text
    <p>Technical Director and one of the founders of <a href="http://www.viovet.co.uk" rel="nofollow">VioVet Ltd</a>. VioVet is one of the UK's largest online retailers (to consumers) in the Vet &amp; Pet industry serving over a quarter of a million unique visitors per month, millions of monthly page views and shipping a 5 figure number of orders per week.</p> <p>Twice featured in the Daily Telegraph VioVet is one of the UK's true business success stories, one of those rare company's that you simply want to deal with. We are <a href="https://www.trustpilot.co.uk/review/www.viovet.co.uk" rel="nofollow">independently rated</a> as the UK's most trusted online retailer of pet food, medication and other pet &amp; equine related products. VioVet supply prescription and non-prescription medication and even the veterinary-only pet foods. Excellence in customer service is central to the business and prices can be around half what you may pay at your local vet/pet shop. Easy to contact advice &amp; order lines and a dedicated vet permanently on hand make help ensure they remain unrivaled for customer care.</p> <p>We make extensive use Nginx, MariaDB, PHP-FPM, jQuery, Elasticsearch, GlusterFS, Git, HAProxy, Keepalived and many other technologies to run our fully bespoke website, back-end and warehouse management system using a considerable server setup with hundreds of processor cores and nearly a terabyte of ram. As a result we can resiliently sever our millions of regular customers a tailored version of our website and other internal systems with an average page generation time of just under 0.04s. All from a well-structured and managed code-base with plenty of strict rules and over 4,000,000 lines of code.</p> <p>We're 8 years old, based in Luton, UK and growing at over 30% year on year. If you're an IT professional (especially PHP developers) and looking for an exciting, past-paced job in a young agile team working from a friendly office in Luton then get in touch. We don't bite.</p>
    plurals
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. POCreate new array from key list in PHP
      singulars
      1. PTQuestion
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. CO@SáT, thanks. I've tried that but no luck again! There must be a way to get this working.
      singulars
      1. POmod_rewrite regex rule with encoded new lines (%0A)
      1. USLuke Cousins
    2. COIf I remove the `^` then I'm back at what I started with originally, which didn't work.
      singulars
      1. PO
      1. USLuke Cousins
    3. COI totally agree that this situation should be avoided and in the client code that would be the usual place to do it, but in this one situation doing it the mysql side would be ideal. This answer would render any index useless but that wasn't actually part of the question (and in the situation not a problem either) as the table would only ever have a handful of rows at a time. Answer accepted, thanks @GoatCO
      singulars
      1. PO
      1. USLuke Cousins
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload