![]() |
![]() |
#26 |
EJ205
Join Date: Jan 2006
Location: Reno, NV
Posts: 1,840
Car: Impreza and an Impreza
Class: AS / CRS PerfStock
"pedal on the right"
|
![]()
It is doable with just a few DB Tables. its all in the table design , and the right SQL statements.
Seariously if someone can give me some Raw data files, or a sample of a raw data file I'll come up with a new set of tools. (or I'll find out how non-trivial it is) and DUDE you can't be searious that you can't figure out 1 method of using a web app on a laptop with out a live net connection? (not that doing so would be ideal , i was more thinking of 1 data collection tool, 1 importer, and 1 web app) Method #1 windows 2k advanced, install SQL 2k, run IIS, (windows xp pro won't work becuase you can't install a server instance of sql. course you could make the web app run on M$ Access, but i generally avoid that) run it all locally ... ![]() Method #2 Design the data collection software to store offline, and to have an upload feature. and when that laptop gets to an internet connection it Then uploads the data... Method #3 still have the results manually written down at the event, Input them into a computer when that person gets home. Method #4 Write an email server and set it up on its own email address and have T&S send it emails Via cell phones Method #5 (okay you got the point now i hope) Nasa spent lots of man hours coming up with a pen that will work in 0 G. the soviets used pencils .... i commonly go for the pencil approach. ![]() ![]() Last edited by A1337STI; 2006-04-12 at 03:35 PM. |
![]() |
![]() |
![]() |
#27 |
EJ205
Join Date: Jan 2006
Location: Reno, NV
Posts: 1,840
Car: Impreza and an Impreza
Class: AS / CRS PerfStock
"pedal on the right"
|
![]()
is Scott going to hate me if i make a new program and it works ?
![]() |
![]() |
![]() |
![]() |
#28 |
Señor Cheap Bastarde
Real Name: Dean Join Date: May 2003
Location: $99 Tire Store
Posts: 9,294
Car: $.04 STI
Class: Fast,Cheap & Reliable=STI
Deal, did somebody say Deal? Oh, Dean, yeah that's me.
|
![]()
While Scott is right, the complexity of Solo timing and scoring is non trivial, we really could use some help!
Using the software is actually not that hard if you can type, and not want to bash the keyboard to hard when it does something stupid. If you want to understand why this topic brings the three of us to a boil so quickly, I encourage you to voulenteer for T&S duty. Get to the event early, and get your name down next to timing computer, timing paper or cone count. You want to go above and beyond, take the initiative, and come out and learn to set up the lights, PA and so forth. The more people that know how to do this stuff, the easier it is on event days for all of us. If you want to help out on coding the scoring software, you have to understand the timing system first, and then the "rules" for scoring. Take a look at our supplemental regulations if you want to get your hands dirty. If we actually have some interest, I would be happy to teach a T&S "class" before one of our meets. Say 6PM at Bully's some week. We really would like more people who can see, think, react, and type working in the bus. Right now during some run groups, it is a refuge for people who don't want to, or can't work the course, and have marginal abilities to do some of the above list, and it kills us when it comes time to produce results in a timely manner. If we could get a core 10 or so people who actually knew the system, and could operate many if not all of it's real time features, many of our reruns, missed cones, and other BS in T&S would magically disappear, and we would make that position one that you had to be pre approved to sign up for, kind of like safety steward. So, if you want to help out, Step Up. Otherwise, you got no rights to complain about how long it takes us to publish results.
__________________
I am a Commodore PET --- Now get off my lawn you kids... ![]() Last edited by Dean; 2006-04-12 at 03:44 PM. |
![]() |
![]() |
![]() |
#29 |
EJ22T
Join Date: Sep 2003
Location: Reno
Posts: 9,445
Car: '93/'01 GF6, mostly red
Class: 19 FP
|
![]()
Pencil method= manually tabulating results and posting to website. 0 G pen=writing sweet software to do it.
__________________
FWD is the new AWD |
![]() |
![]() |
![]() |
#30 | |
JDM Cowboy
Real Name: Nick Join Date: Oct 2003
Location: Somewhere
Posts: 8,642
Car: 2015 Mazda 3
|
![]() Quote:
__________________
While a standard engine is powered by a belt connected to the crankshaft, a turbo engine runs on its own exhaust steam, making it more energy efficient. -- CNN |
|
![]() |
![]() |
![]() |
#31 |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]()
Alex:
First, I'd like to know how a web application is going to communicate with the timing lights, which is where we'd like to go w/ this software. I could be wrong but I don't think mysql/php has a way to spawn a thread to read from a serial port and write to shared memory. The real solution to the problem is to write a windows application that doesn't require any rediculous steps like uploading scores via a cell phone ![]() And in general, running an "application" on a network designed to share text files will *always* be the zero-g pen and *never* the pencil. Using port 80 for anything beyond the serving of pure text documents is a hack. Hell, I'm surprised email even works. Now I'm not trying to come down on your enthusiasm, but enthusiasm alone doesn't solve problems. You need experience w/ the problem 1st. You learn the current T&S software, the way season points are managed, be chief of timing and scoring for a season or two, and figure out when web services are useful vs. when regular applications are useful, and then we can talk about a new software development project. I thought it was easy too when I first took the job of T&S chief in 2004... it's not easy, it sucks, especially when the design requirements change every year. For now, the software I wrote will be updated to the new scoring rules before the next event, and will be plenty adequate for this years results.
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
![]() |
![]() |
![]() |
#32 | |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]() Quote:
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
|
![]() |
![]() |
![]() |
#33 | |
Señor Cheap Bastarde
Real Name: Dean Join Date: May 2003
Location: $99 Tire Store
Posts: 9,294
Car: $.04 STI
Class: Fast,Cheap & Reliable=STI
Deal, did somebody say Deal? Oh, Dean, yeah that's me.
|
![]() Quote:
It's not about web servers on laptops, it's about dealing with the human component of this system, the poor basic design of the timing application, and last but not least, our convoluted rules for individual event and season scoring. I can give you most if not all of last year's data, but without context, it will be mostly meaningless. I'm glad you want to help, and personally would appreciate the help, but rather than just saying how easy it is to do, try understanding the problem first. Pretend this is one of those sheets that you got in grammer school with all these instructions on them telling you to do a bunch of random stuff, but the first instruction was "read the entire sheet before doing anything", and the last said "ignore all other directions, and write your name on the piece of paper, and turn it over on your desk" Don't be the kid singing "mary had a little lamb" and doing long division of a twelve digit number, instead, go read the scoring rules, and come back and ask questions...
__________________
I am a Commodore PET --- Now get off my lawn you kids... ![]() |
|
![]() |
![]() |
![]() |
#34 | |
Captain Turbo
Join Date: Feb 2004
Location: Reno
Posts: 3,318
Car: 05 STi
|
![]() Quote:
![]() ... that's how I got the job! |
|
![]() |
![]() |
![]() |
#35 | |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]() Quote:
![]()
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
|
![]() |
![]() |
![]() |
#36 |
JDM Cowboy
Real Name: Nick Join Date: Oct 2003
Location: Somewhere
Posts: 8,642
Car: 2015 Mazda 3
|
![]()
I think Mike agreed to upload the files after the T&S cheif was done with them
![]() Now he's the dude who has to tabulate the results.
__________________
While a standard engine is powered by a belt connected to the crankshaft, a turbo engine runs on its own exhaust steam, making it more energy efficient. -- CNN |
![]() |
![]() |
![]() |
#37 | |
Captain Turbo
Join Date: Feb 2004
Location: Reno
Posts: 3,318
Car: 05 STi
|
![]() Quote:
![]() What I really meant was that I didn't want to be the type of T+S chief who says things or does stuff. Plus there's no internet connection in the bus, so it's hard to pass the time. |
|
![]() |
![]() |
![]() |
#38 | |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]() Quote:
![]()
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
|
![]() |
![]() |
![]() |
#39 | |
Señor Cheap Bastarde
Real Name: Dean Join Date: May 2003
Location: $99 Tire Store
Posts: 9,294
Car: $.04 STI
Class: Fast,Cheap & Reliable=STI
Deal, did somebody say Deal? Oh, Dean, yeah that's me.
|
![]() Quote:
But to do those you have to have the event data... So we enter the grey area... We actually had a pretty good handle on getting event results out last year, but the new Street tire rules for this year are making it a bitch. Should we have maybe done a little more planning and prep before the season started, yes... Are we paying the price now? Yes... We will get a handle on it between the 3 or more of us. Just bear(or is it bare) with us.
__________________
I am a Commodore PET --- Now get off my lawn you kids... ![]() Last edited by Dean; 2006-04-12 at 04:35 PM. |
|
![]() |
![]() |
![]() |
#40 |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]()
Dean, like I mentioned earlier, I'm updating the software that was working well at the end of the season last year to handle the new rules. I'm also adding the ability to generate per-round results so we won't have to hand merge Street Tire classes w/ their parent classes.
Hell, we actually might be able to get away with using AXWare w/o ever entering names, all we really need are the class/number pairs and the times. Though, the announcer wouldn't get jack to talk about, since we both know how bad AXWare is about reporting things like run count if you haven't pre-entered a driver into the roster.
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
![]() |
![]() |
![]() |
#41 |
EJ205
Join Date: Jan 2006
Location: Reno, NV
Posts: 1,840
Car: Impreza and an Impreza
Class: AS / CRS PerfStock
"pedal on the right"
|
![]()
I never wrote that it was Easy; I did write I am in the belief with some raw data I could setup something that would work, which at some point in the system would include a Database.
Ya I’d like to see the results, but I honestly don't care if it takes 3 more weeks. I’m stoked to find a safe recreational outlet for driving. I'm stoked its so affordable, which is only due to volunteer work. Which I am very thankful for. I find I work best when I start at the start and attempt to feel out the whole problem, (i.e. get what ever raw data it starts as and think of how to get to the end result) which was my goal here, I was hoping someone would just say "here's the raw data, take a look " But Apparently this is a very sensitive toe I was about to Drive over, you could have saved a lot of typing (and a few unintentional jabs at your ego) by putting something like "This is a bit of a pet project of Mine, thanks for the offer, but no thanks" and if its easier for you to accept, Okay its impossible And Cost prohibitive to integrate a DB with your system. |
![]() |
![]() |
![]() |
#42 | |
Señor Cheap Bastarde
Real Name: Dean Join Date: May 2003
Location: $99 Tire Store
Posts: 9,294
Car: $.04 STI
Class: Fast,Cheap & Reliable=STI
Deal, did somebody say Deal? Oh, Dean, yeah that's me.
|
![]() Quote:
The first events are always the worst becasue of all the changes. You guys were brave to not use last year's driver data at all. I'd be happy to do some cleanup and correlation of driver info back into AXWare if you want. And we have to enter the new info somewhere, so it may as well be in AXWare at the event. All we need is the last raw event file to start the next one, so as long as we can get names and cars straightened out once, we should be fairly well off moving forward. The problem we ran into last year was we kept using the same base membership file rather than using the last event, or updating the base file, so we had to make the same changes event after event.
__________________
I am a Commodore PET --- Now get off my lawn you kids... ![]() |
|
![]() |
![]() |
![]() |
#43 | |
Señor Cheap Bastarde
Real Name: Dean Join Date: May 2003
Location: $99 Tire Store
Posts: 9,294
Car: $.04 STI
Class: Fast,Cheap & Reliable=STI
Deal, did somebody say Deal? Oh, Dean, yeah that's me.
|
![]() Quote:
What we are trying to say is walk before you run. The reason this software sucks so bad is that Vitek, the guy who wrote did a lot of things similar to what you are describing, and didn't think about the ramifications. The data from a couple last year events are attached... Knock yourself out... But don't ask us for any context, or help understanding the issues, because that's not how you roll... Use Windows Jet DBs, they are free. Don't forget to assume that the data for the next event will be completely different. I was young, and knew everything once too.... Enjoy...
__________________
I am a Commodore PET --- Now get off my lawn you kids... ![]() |
|
![]() |
![]() |
![]() |
#44 | |
EJ22
Join Date: Mar 2005
Location: Elk Grove, CA
Posts: 450
Car: 2005 WRX STi
"I'm sideways and in control... I look good."
|
![]() Quote:
WinXP Pro w/ IIS. MSDE for the database. MSDE has a 2GB database limit and slows itself down when more than 5 connections to it are opened. Java GUI --> IIS --> MSDE Then later if you need to expand you can move up to SQL Server. |
|
![]() |
![]() |
![]() |
#45 | |
The Doink
Real Name: Scott Join Date: Nov 2002
Location: Portland, OR
Posts: 20,335
Car: '09 OBXT, '02 WRX, '96 Miata
Class: PDX/TT-6
The way out is through
|
![]() Quote:
Also, the idea of writing and testing a web application to be used locally makes me want to eat my own face. There are development tools and languages that are about 1000 times better than what you get w/ a web interface designed specifically for writing local applications. Just because you can get something to work as a "web application" does not make it the correct solution. Web apps are still about 20 years behind the curve as far as user interface capabilities when compared to true native applications. Everyone together now: "The best way to write a windows application is to write a windows application." It's not: "Create an online database, write a script that accesses the database, implement a flash interface that gives you a slick (non-standard) GUI but only works on Internet Explorer and only if you have the latest updates, create a downloadable Java app that will talk to the serial port for timing I/O but only if the user has administrator privledges and has updated to the latest version of Java from Sun, interface the Java comms app to the flash page, and wrap the whole thing into a complicated cookies-based state machine that will never be 100% stable because the web is inherently stateless. Oh and nevermind the security issues that will allow anyone with an associated degree in 'web guruism' to enter their own run times into the database at will." Dan, if your business thinks local web apps are the way to go, someone at your company should be fired IMO. The *only* reason to go that route is if you already had the web software written and you're using it while someone implements a local version. Sorry to rant, but this is a pet peeve of mine... The internet is a fucking mess. Basic web browsing (plain old text and pictures) is pretty good, and the whole message board thing is pretty well sorted out. Online shopping is getting pretty close to decent (mostly just out of necessity) but is still very hit-or-miss based on the vendor. However, in general, the internet is chock full of terrible code, poor design practices, awful user interfaces, and security holes large enough to barrel roll a triple-7 through. Having done both apps and web development for the last 10 years, choosing to keep that web-based shit off my local system is a no-brainer. There is no reason to install $1000 in licenses, 15 GB of software, and 7 different supporting applications (that all need to be constantly updated online), and one hacked together web-app just to get the functionality that a 200k C++ Builder app that took 15 hours to design, implement, test and debug is insane.
__________________
Is you is, or is you ain't, my con-stit-u-ints? |
|
![]() |
![]() |
![]() |
#46 | |
EJ22
Join Date: Mar 2005
Location: Elk Grove, CA
Posts: 450
Car: 2005 WRX STi
"I'm sideways and in control... I look good."
|
![]() Quote:
I didn't say what we did here was pretty. I just wanted to make the suggestion of a server OS and SQL server slightly more affordable. (the controllers we work with use the java inteface and the manufactuer decided to make the offline programming tool similar to the live device) Agreed. Make a real windows app. |
|
![]() |
![]() |
![]() |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
MikeK's new heroes | Nick Koan | Off Topic Chat | 1 | 2007-01-14 01:02 PM |
How can I disable email notification of new posts? | left footed whooten | Website News & Issues | 3 | 2006-09-18 10:32 AM |