![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Oooh. I'm being productive.
Apr. 1st, 2004 12:31 amThanks to Hythloday, ![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
blankinfinity and other people on IRC, I made my first use of SQL. It's just practising, since I'll have to do it all again on a new server, but I did the immensely lame (in everyone else's eyes, I'm sure) task of a: updating MySQL (Erm, I forgot my password), and installing phpBB2 to see how it works. It's brilliant, of course - I want something like this so I can update the website, eventually - a front end to SQL which does all the dirty bits for me. I can probably work out some of PHPBB, and of course it does all the lovely things I wanted to work out - administering users and what they can see, maintaining the database etc.
Getting it to work on OS X and make sense required a little reading since I have Apache2 installed, instead of 'Personal Web Sharing' (AKA Apache1), and PHP4. Most Mac OS X hint pages are aimed at the latter Apache solution which is part of OS X (OS X server also has PHP and SQL, I think). Main changes are of course config files, and stuff any fule should know, like 'Sites' ought to be 'public_html' - I guess the proper way of fixing that would be to go wandering into the right config files, but I just renamed the directory :D
Running a nice GUI for SQL, but still defeated by user management, which is why I'm doing this on a local, firewalled subnet until I understand how to administer this stuff.
Why the sudden interest? I reckon relaunching Freelance under a new, snappier title and aimed at more general photography/imaging will work, and I'm being paid to produce and run the website. I've put off knowing how to do this for far too long, and it's time to learn and earn a little cash with it. Maybe I'll keep my Sera after all, because if I can do this for myself, maybe I'll get back into offering solutions for local companies, and fuck 'em if they want everything for £50 - if I can deliver something I think is /worth/ paying for, I'll ask for the money.
OTOH, if I have a template ready and their site takes 2 minutes, then I'll take the £50. I may need to eat sometime ;)
Now I need to put the info bart (forgotten LJ tag, will edit) gave me to good use, and work out the advice re: pdf, XML etc.
Next task: eBooks - I thought they were text files. I shall be hunting these.
Spotted Peter Coffin lurking on the Newton Talk mailing list. Amusing :) I got my eMate a rare (heh) RAM upgrade, so all my Apple-y toys are getting extra RAM, the G5 getting a much needed kick up to 2.5Gb from the measly 512Mb it had.
Considering selling the dual PIII PC, or maybe throwing Windows away, installing SUSE (XFree86, so presumably the closest I'll get to MacOS) and using it as another development box.
blankinfinity and other people on IRC, I made my first use of SQL. It's just practising, since I'll have to do it all again on a new server, but I did the immensely lame (in everyone else's eyes, I'm sure) task of a: updating MySQL (Erm, I forgot my password), and installing phpBB2 to see how it works. It's brilliant, of course - I want something like this so I can update the website, eventually - a front end to SQL which does all the dirty bits for me. I can probably work out some of PHPBB, and of course it does all the lovely things I wanted to work out - administering users and what they can see, maintaining the database etc.Getting it to work on OS X and make sense required a little reading since I have Apache2 installed, instead of 'Personal Web Sharing' (AKA Apache1), and PHP4. Most Mac OS X hint pages are aimed at the latter Apache solution which is part of OS X (OS X server also has PHP and SQL, I think). Main changes are of course config files, and stuff any fule should know, like 'Sites' ought to be 'public_html' - I guess the proper way of fixing that would be to go wandering into the right config files, but I just renamed the directory :D
Running a nice GUI for SQL, but still defeated by user management, which is why I'm doing this on a local, firewalled subnet until I understand how to administer this stuff.
Why the sudden interest? I reckon relaunching Freelance under a new, snappier title and aimed at more general photography/imaging will work, and I'm being paid to produce and run the website. I've put off knowing how to do this for far too long, and it's time to learn and earn a little cash with it. Maybe I'll keep my Sera after all, because if I can do this for myself, maybe I'll get back into offering solutions for local companies, and fuck 'em if they want everything for £50 - if I can deliver something I think is /worth/ paying for, I'll ask for the money.
OTOH, if I have a template ready and their site takes 2 minutes, then I'll take the £50. I may need to eat sometime ;)
Now I need to put the info bart (forgotten LJ tag, will edit) gave me to good use, and work out the advice re: pdf, XML etc.
Next task: eBooks - I thought they were text files. I shall be hunting these.
Spotted Peter Coffin lurking on the Newton Talk mailing list. Amusing :) I got my eMate a rare (heh) RAM upgrade, so all my Apple-y toys are getting extra RAM, the G5 getting a much needed kick up to 2.5Gb from the measly 512Mb it had.
Considering selling the dual PIII PC, or maybe throwing Windows away, installing SUSE (XFree86, so presumably the closest I'll get to MacOS) and using it as another development box.
