Posts Tagged ‘mysql’

Best way to store IP addresses in MySQL

By David Pratt / Tags: mysql, php / 11 Comments » / Published: 10-08-10

It’s tempting to store IP addresses in a database as a varchar of length 15 in the absence of a dedicated IPv4 field type in mysql, but that isn’t the most efficient way of doing so…

Importing large files into mysql with phpmyadmin

By David Pratt / Tags: mysql, phpmyadmin / 75 Comments » / Published: 18-01-10

A tutorial that explains the steps you need to take in order to import large (2Mb+) SQL files into phpmyadmin

How to set up a local server on Windows

By David Pratt / Tags: apache, mysql, php, server, wordpress / No Comments » / Published: 11-05-09

Instructions on how to setup a local server manually on a windows box; running Apache, MySQL and PHP.

Who is daipratt?

daipratt.co.uk is the online home of David Pratt.

What do I do?

Broadly speaking, I specialise in creating websites. Not the design, but the stuff that makes it work, web application development some might call it. Expect to read about JavaScript & jQuery, new web technology, innovative front-end solutions, SEO, Drupal & PHP, and the occasional post about where I feign knowledge in marketing and analytics.

If you'd like to talk to me about a project you can either email me or say hello over at my companies website.

Top tags

Post archives

To-do list

Get some HTML 5 mark-up involved
More CSS3!
Use micro-formats on the contact page
Properly integrate the plug-in CSS & JS
Clear up the chaff in the <head>
Write appropriate <meta> keywords and descriptions
Write the content for the permanent pages
Power this list by remember-the-milk!
Sort the 404 error page
Sitemap
Sort the right nav bar out on post pages - this page is WAY too long!
Related pots
Clear up the tags
Mobile version
Use some form of syntax highlighting for the code snippets
Launch site

Lifestream
- Well put... "The modern robber obtains prior approval from the institution he is fleecing." http://t.co/U6Y9M9QZ @GeorgeMonbiot [daipratt]
  — 25-01-12 via Twitter
- Maddox nails #SOPA http://t.co/S8dbSywk [daipratt]
  — 19-01-12 via Twitter
- RT @FuckingDevTips: The hard fucking problems are the ones worth solving. [daipratt]
  — 17-01-12 via Twitter
- Shared Public Data Sets : Amazon Web Services.
  — 15-01-12 via Delicious
- Shared JavaScript pattern and antipattern collection.
  — 15-01-12 via Delicious
- Decent collection of JavaScript & jQuery patterns and anti-patterns #javascript #jquery http://t.co/tYYkDYrN [daipratt]
  — 15-01-12 via Twitter
- Good article on startup ideas... think big! http://t.co/x31r4Ian #startup [daipratt]
  — 15-01-12 via Twitter
- RT @venturehacks: “The reality is that for most businesses, they don’t need more cash, they need more brains.” – @mcuban, http://t.co/K0 ... [daipratt]
  — 14-01-12 via Twitter
- Liked impress.js | presentation tool based on the power of CSS3 transforms and transitions in modern browsers | by Bartek Szopka @bartaz.
  — 10-01-12 via StumbleUpon
- Liked 2 websites.
  — 26-12-11 via StumbleUpon
  - PEAR - PHP Extension and Application Repository
  - http://tc.v19.cache3.c.bigcache.googleapis.com/static.panoramio.com/photos/original/28485008.jpg?redirect_counter=1
- Liked 2 websites.
  — 25-12-11 via StumbleUpon
  - Top 100 Hotels &Resorts in the World : Conde Nast Traveler
  - Free Worldwide Travel Guides - Wikitravel
- Liked 8 websites.
  — 18-12-11 via StumbleUpon
- Shared something went wrong.
  — 15-12-11 via Delicious
- RT @jonsnowC4: How come Fred Goodwin: guilty + disgraced RBS operative, still has a knighthood? Does the 'system' seriously have no mean ... [daipratt]
  — 13-12-11 via Twitter
- Liked Profitable Chart Patterns For Swing Traders.
  — 12-12-11 via StumbleUpon
- Liked 3 websites.
  — 03-12-11 via StumbleUpon
- Drupal Case Study for Property Place http://t.co/LqhuNaJX [daipratt]
  — 01-12-11 via Twitter
- Gutted I missed deadmau5 in London - looked like it was epic: http://t.co/ZdBuQ2GD [daipratt]
  — 29-11-11 via Twitter
- RT @Zoocha: Check out our case study on http://t.co/DxDipWSg that shows how to deal with 0.5m nodes and 350GB of images! http://t.co/unF ... [daipratt]
  — 29-11-11 via Twitter
- Liked 4 websites.
  — 28-11-11 via StumbleUpon
- Decent CSS property / documentation lookup app http://t.co/WwKCn7om #css [daipratt]
  — 27-11-11 via Twitter
- Liked 14 websites.
  — 26-11-11 via StumbleUpon
- Shared Top 10 Novels of the 2000s | Entertainment | Never Let Me Go | TIME.com.
  — 26-11-11 via Delicious
- Shared 21 Books Every Entrepreneur Should Read.
  — 26-11-11 via Delicious
- Shared The Hand-picked jQuery Plugins Repo. Supercharge your website!.
  — 22-11-11 via Delicious

daipratt.co.uk