Ancient lappy for scouting

So I had this neat idea and wasn’t totally sure where to post it…but I guess it falls under this category. I believe my team has gained a few old laptops (486, 16mb ram). We have been needing a simpler way to do scouting and these laptops came to mind. My idea was to put a webserver on it, a small window manager (for linux…of course), along with a mySQL database. The only problem is that I’m not sure if that old machine can handle all that. I’ve never run any sort of database software nor ever even thought about programming for one. Anyone know what kind of machine I would want to do that?

(All you people with your fancy new Vaio laptops just for display purposes…sheesh…Until this year, our robot programming has been done on a computer using a proc made my IBM and it’s oler than me))

My basic plan was to create a web interface like a search engine then be able to type in or select what I want to limit. IE: check a box that says Tether and box that says 2 goals then search and print all the results. Much easier than flipping through every page in a notebook and trying to find pictures on 40 different digital cameras.

well, just throwing data into a mysql db is very simple and doesn’t load the system at all. If you wanted to do complex queries and sorting, that could lag a little. I can’t find minimum requirements for mySQL on their site but it shoudl be pretty low. If you were going to install apache w/ php i don’t think its very hard on the processor. I run an apache server on my 400 mhz celeron with 256 ram, and it runs fine, which could be the extra ram. my only advice is to try it out and see what happens. also, an online version of this that all teams could access would be wonderfull. the only problem would be to get everyone to update their team info. do you think first would send out an email informing all of the teams of a site like this?

Honestly, you’d be better off with a commercial database program. From what you’ve described, even the old ClarisWorks 4.0 (anybody remember that?). Are you trying to do this in a distributed manner, such that multiple people with multiple laptops could all be accessing and updating the same database? If so, I’d recomend dumping MySQL and the webserver on some “server” in your pit area and just having regular browsers on the laptop.

mySQL and other database programs may be too intense memory wise with only 16mb. What specifically are you planning on doing? It may be fine with simple querys, and manipulation, but if you want something that keeps updating itself every few seconds with new data, it may not be able to keep up.

I don’t think it will be anything to complex… Basically, whenever someone from the team wants to find something out about a team or stuff about robots…they’d go to a website on that computer and search for something like ‘robots with tether 2 goal grabbers and balls’ then it would query the mySQL server


mysql> SELECT * FROM robots WHERE tether = "T" AND goals = "2" AND balls = "T";

Then just reply with the results of the find.

I happen to like the idea of bringing a a desktop or something to act as the server…but I’d be wanting wireless access and I kinda doubt that the laptop will accept 802.11b cards :slight_smile:

I shall be looking into the lappy specs and see if I can’t up the memory to at LEAST 32mb (which I figure would do the job…) Do laptops need special memory? I’ve never worked with them before…

Anyone willing to donate a laptop to a good cause? :smiley:

nope, but between now and february I’m hoping on getting an ibook, sorting out all of the usb problems, and etc, so that when all is ready I’ll have the best programming box around :smiley:

evulish,
if you’re only accessing the data off one machine, MySQL/PHP is overkill. ALL decent stand-alone database programs will let you do the type of search you are talking about and display the results in any form you like.

As for special RAM, you need special small-outline RAM. With the age you are talking about, though, I honestly don’t know what the specifics would be.

Originally posted by evulish *
** Basically, whenever someone from the team wants to find something out about a team or stuff about robots…
*

… basically me ;)…

… give evulish ideas… help him find out the craziness of the unknown AGED laptop!!!

/ma wants sanity!

*Originally posted by rbayer *
**evulish,
if you’re only accessing the data off one machine, MySQL/PHP is overkill. ALL decent stand-alone database programs will let you do the type of search you are talking about and display the results in any form you like.

As for special RAM, you need special small-outline RAM. With the age you are talking about, though, I honestly don’t know what the specifics would be. **

What are some other database programs? I have never looked into any of this stuff and I don’t know what’s good, bad, or indifferent…

As for you weedie…nothing will ever make you sane :slight_smile:

Has anyone ever approached a big computer company, or retail store for some free laptops for some of their travel members? I think it would be cool to see if they are interested.

Okay. I got the laptop tonight. It’s an IBM Thinkpad 701C with a 80486 75mhz proc and 20mb ram. It’s a pretty decent laptop. I got it with a docking station (mouse, kb, video, parallel, serial…) and an external floppy drive. There’s no battery yet but I’m not exactly wanting to walk around with it. It’s pretty cool…it has a butterfly keyboard.

Right now, I’m working on getting the hard drive backed up which seems to be a bit of a problem. I have no way of transfering files other than via floppy disk. 211mb of data by way of floptical is not fun. I’m scouring friends’ computer parts in hopes of finding a parallel zip drive. I JUST WANT WIN95 GONE(&#$

After that, I should be able to install Slack 7.0. I read it doesn’t play well with new kernels (and what would the advantage be of installing the newest stuff? Yeah…USB support is really an issue) Once I get linux installed, I’ll be installing database software, Apache, and Netscape. It’s gonna be sweet. Gotta do a bit of programming for it, though. I’ll also have to learn someone how to maintain it :slight_smile: (AFAIK…I’m the only linux user on my team…but I’m in the process of converting)

I should be getting a memory upgrade soon. 64mb ram drool

Umm… how exactly do you plan on fitting Slack 7 along with Apache, MySQL and X Windows on 211MB?

As for moving the data, just take out the hard-drive and plug it in to a desktop, assuming it is ATA and not some old, proprietary stuff.

Hmm, with that littel bit of space, slack 7.0 is overkill. As a personal linux user, I spent many hours jamming things on my alppy, up until it’s unfitful end. I recommend zipslack, it is small compact and easy to tweak to run of ext2 or 3 or something else like reiserfs. You can pick out the little bits you don’t need, get apache on there and some other stuff. X is out of the question though, plus with zipslack it is almost impossible I found, dependencies and such. So get zipslack and tweak it. I ran apache on it but haven’t tried my sql, also, it ran off a 105mb ext2 parttion and 32 mb swap partion
how much more would the mysql need?

Matt Krass

Well, I really do need X on there. I won’t be running a window manager, just netscape. (I doubt the scouting people would much care for command line).

And…the hard drive is a 700mb hard drive. Only 211 of it is used.

Also, laptop hard drives are a bit different than normal hard drives. It won’t fit into a PC without a special adapter. I really don’t feel like putting money into a worthless laptop :slight_smile:

Oh, with 700mb just load up regular slack, from expert install trim it down and just have networking, don’t use their X unless you want headaches, it never wokred for me but maybe you will have better luck, and then just setup apache and mysql. Try to keep a lot of free space. Never know when you temporarily need an extra 300mb for source project, db backup whatever. Plus, it is easier, it just is. Hope that helps, and I’m glad Ican ifnd other linux users. Talk to you later,

Matt

P.s. If anyone is interested my winamp3 meta string thing doesn’t seem to work, it never shows what song I am playing…any help is appreciated.

Can slack be easily installed from floppies? (and only floppies? :)) Actually…I may be getting my hands on a parallel port Zip drive (not to install Zipslack with…just to move data…and hopefully slackware :P)

hmm, not sure no access at all to cd. Lets see, I have an idea but it needs some refining so I’ll get back to you. You seem to be anxious about this, such fast replies. Maybe you could get me on aim: ace32456

Ok I checked into it. Slack can be installed via floppies, it is just a matter of breakinbg it up properly. Check out google groups and run a search on slackware floppy install, depending on what need depends on what you copy, you hsouldn’t need it all HTH

Matt

P.s. I am almost always on aim at Ace32456 so contact me if you wish :slight_smile:

I understand that you don’t like micro$soft, but sometimes their products are useful for a little small stuff. Unless you plan to make this a MAJOR thing, you could use ms Access. I use it for our teams scounting. It’s a database with nice forms, and reports that format data for printing/ easy viewing. It uses VBA which is good for small, quick programming. I understand that if you want to do this networked on many computers then they each have to run Access, and they are old, so i’m not sure of the reqs. that access has. Yes, you could do it in html w/ a mysql db, but that might me a lot of work. Personally, get a win binary for apache and a mysql db. I don’t think that it has really any system reqs.