goemaw.com
General Discussion => Essentially Flyertalk => Topic started by: SwiftCat on June 03, 2013, 08:41:07 PM
-
What do I need to learn?
HTML? PHP? MySQL?
Are those hard to learn?
How expensive is it to hire someone to write the website for me?
-
what is the purpose of the website?
-
It's a K-State fan site/forum
-
PSYCH!
I want it to display searches of a database. The database will be track and field results.
-
Ask Trim. He is the Main Administrator.
-
Ask Trim. He is the Main Administrator.
TRIM!
-
for something like that, if you don't need it too be too slick, just display facts in some form thats not too hard on the eyes, i'd recommend a tomcat/DB/Apache structure. Apache for webhosting, just write some basic HTML pages to display, use tomcat and the underlying java to connect/issue queries to your database and display it in the HTML wrapper, then whatever database you have hosting this (MySQL? PostGreSQL?) If you don't have a programming background i'd say thats your quickest path forward, as the only "coding" is writting the tomcat hooks.
For more simple webpages (non-DB integrated) there are tons of solutions to use some drag and drop interface to make a webpage, but i'm not certain how much low level control they'd allow you, so that you could integrate some DB connections somehow.
Another thing, i don't know if you are going to be getting these sports results sent to you in some kind of machine readable format (i.e you don't have to enter in everything by hand) but if you are going to be entering in everything by hand anyway, i'd just crowdsource it and stand up a wiki, make the people with the scores (or designated volunteers) upload it themselves... MediaWiki (the software that runs wikipedia) is free and open source so you can stand one up fairly easily and everyone is already familiar with the interface (who doesn't use wikipedia?)
-
You don't need to learn to code to have a website, just get a cheap hosting account and use a wordpress theme. Tons of free themes using php/mysql. You could even get a free wordpress blog and get the theme you need if you don't care about the url name.
-
i wrote my own assembly compiler and use that to create elite websites
-
You don't need to learn to code to have a website, just get a cheap hosting account and use a wordpress theme. Tons of free themes using php/mysql. You could even get a free wordpress blog and get the theme you need if you don't care about the url name.
This is what i was driving at, if wordpress lets you hook into some php/mysql (though tomcat>php, imo) then by all means use that... will wordpress host your DB for you or do you need to host off server? Does it have some abstraction so that you're only exposing server to server communications for security reasons between webserver and DB?
-
You don't need to learn to code to have a website, just get a cheap hosting account and use a wordpress theme. Tons of free themes using php/mysql. You could even get a free wordpress blog and get the theme you need if you don't care about the url name.
This is what i was driving at, if wordpress lets you hook into some php/mysql (though tomcat>php, imo) then by all means use that... will wordpress host your DB for you or do you need to host off server? Does it have some abstraction so that you're only exposing server to server communications for security reasons between webserver and DB?
Bro he is wanting to host track and field results not felix rex's dossier.
-
youd be surprised how some people get their jollys off, an insecure DB connection is some russian haker's wetdream, no mater how small timey it is.
-
what makes you think anyone around here knows anything about building/running a website?
-
:lol:
-
for something like that, if you don't need it too be too slick, just display facts in some form thats not too hard on the eyes, i'd recommend a tomcat/DB/Apache structure. Apache for webhosting, just write some basic HTML pages to display, use tomcat and the underlying java to connect/issue queries to your database and display it in the HTML wrapper, then whatever database you have hosting this (MySQL? PostGreSQL?) If you don't have a programming background i'd say thats your quickest path forward, as the only "coding" is writting the tomcat hooks.
For more simple webpages (non-DB integrated) there are tons of solutions to use some drag and drop interface to make a webpage, but i'm not certain how much low level control they'd allow you, so that you could integrate some DB connections somehow.
Another thing, i don't know if you are going to be getting these sports results sent to you in some kind of machine readable format (i.e you don't have to enter in everything by hand) but if you are going to be entering in everything by hand anyway, i'd just crowdsource it and stand up a wiki, make the people with the scores (or designated volunteers) upload it themselves... MediaWiki (the software that runs wikipedia) is free and open source so you can stand one up fairly easily and everyone is already familiar with the interface (who doesn't use wikipedia?)
I looked for drag and drop solutions, but I didn't see anything that would query MySQL databases. Maybe I didn't look hard enough.
Other than tomcat, that's what the plan was. I am learning some basic HTML/CSS right now, and I have a solid enough grasp on the MySQL database. It will need some tweaking, but from the research I've done it sounds like the best solution for what I want to do. I was thinking I would just code with html and php to connect to the MySQL datbase, but you say Tomcat would be better than that? I'll look that up as soon as I finish this post.
Currently the results are in PDF files. Some are actual documents, others are scans of paper results. Ideally I would be able to grab results from the non-scanned PDFs. This is starting out as a 1 school site. If it all goes smoothly, I'll move to the whole league and etc. etc. If it got big enough (state-wide) I would have to start implementing crowd sourced results. But I think that's more trouble than it's worth currently. Nor do I think a wiki page would be the correct way to go about crowd sourcing but I could be wrong.
-
You don't need to learn to code to have a website, just get a cheap hosting account and use a wordpress theme. Tons of free themes using php/mysql. You could even get a free wordpress blog and get the theme you need if you don't care about the url name.
This is what i was driving at, if wordpress lets you hook into some php/mysql (though tomcat>php, imo) then by all means use that... will wordpress host your DB for you or do you need to host off server? Does it have some abstraction so that you're only exposing server to server communications for security reasons between webserver and DB?
If there is an easy way to hook into a MySQL DB, then I'm all for that. I just didn't see anything when I looked the first time.
-
what makes you think anyone around here knows anything about building/running a website?
I'm just trying to start interesting threads in the dog days of combo-fanning season.
(I'll ask this question on tmb if you really want me to.)
-
it's honestly probably going to be easiest to just use php until you run into a reason not to. yes people can easily write bad code in it but people write bad code in every language. might as well learn the basics in the process instead of getting hung up on details (as long as you're not taking people's money, SSNs, that kind of stuff)
-
might as well learn the basics in the process instead of getting hung up on details (as long as you're not taking people's money, SSNs, that kind of stuff)
I'm not.
This is also kind of a hobby/learning experience. I wouldn't mind learning a little code, I just want to know what the best way to go about it is.
-
might as well learn the basics in the process instead of getting hung up on details (as long as you're not taking people's money, SSNs, that kind of stuff)
I'm not.
This is also kind of a hobby/learning experience. I wouldn't mind learning a little code, I just want to know what the best way to go about it is.
php will probably be easier/quicker to setup & learn when first starting out, but the tomcat/java route is fine as well. you won't hit any technical limitations with either for your project
-
might as well learn the basics in the process instead of getting hung up on details (as long as you're not taking people's money, SSNs, that kind of stuff)
I'm not.
This is also kind of a hobby/learning experience. I wouldn't mind learning a little code, I just want to know what the best way to go about it is.
i wouldn't mind learning a little code either, i mean, what the eff else would i be doing?
-
I had a website making class at K-State and you needed to know code. I was awful at it. I got a lot of help from my best friend. I hope my former teacher doesn't see this. :crossfingers:
-
what makes you think anyone around here knows anything about building/running a website?
I'm just trying to start interesting threads in the dog days of combo-fanning season.
(I'll ask this question on tmb if you really want me to.)
just joshing
-
The cool kids all use node.js.
http://expressjs.com/ gives you a framework to start. CouchDB for NoSQL on the back end or PostgreSQL if you want SQL.
And nginx instead of Apache on the front.
-
it's incredibly pud. just tell saul and chings what you want and then yell at them everytime they do it not exactly how you want until it's how you want.
-
The cool kids all use node.js.
http://expressjs.com/ gives you a framework to start. CouchDB for NoSQL on the back end or PostgreSQL if you want SQL.
And nginx instead of Apache on the front.
took the words and other stuff right out of my mouth
-
Copy what someone else has done and change it just enough to NOT GET SUED HAHAHAHA
-
it's incredibly pud. just tell saul and chings what you want and then yell at them everytime they do it not exactly how you want until it's how you want.
:lol:
-
You don't need to learn to code to have a website, just get a cheap hosting account and use a wordpress theme. Tons of free themes using php/mysql. You could even get a free wordpress blog and get the theme you need if you don't care about the url name.
This is what i was driving at, if wordpress lets you hook into some php/mysql (though tomcat>php, imo) then by all means use that... will wordpress host your DB for you or do you need to host off server? Does it have some abstraction so that you're only exposing server to server communications for security reasons between webserver and DB?
If there is an easy way to hook into a MySQL DB, then I'm all for that. I just didn't see anything when I looked the first time.
http://www.makeuseof.com/tag/stepbystep-mysql-tutorial-selfhosted-wordpress-bloggers/
-
The cool kids all use node.js.
http://expressjs.com/ gives you a framework to start. CouchDB for NoSQL on the back end or PostgreSQL if you want SQL.
And nginx instead of Apache on the front.
took the words and other stuff right out of my mouth
And my mouth.
-
I have a page on blogspot.com that I use as a faux news outlet covering my fantasy baseball/football league's. I do power rankings/trade rumors/fake interviews, the bro's love it.
If you have gmail its pretty simple to set up.
-
I have a page on blogspot.com that I use as a faux news outlet covering my fantasy baseball/football league's. I do power rankings/trade rumors/fake interviews, the bro's love it.
If you have gmail its pretty simple to set up.
This sounds like exactly what I'm looking for. Thanks.
-
Say I have a program running. There's data on this program that I want to use. I want to take that data and have it put in some database program, and from there have it interact with other programs (not important now, crossing that bridge later). What do I need for a tool that scrapes that program (through images/continual screenshots of the program, or at least when I hit execute it takes a screenshot and scrapes), and what to use for some database? And would need to be instant. Low programming experience only used stuff like sikuli, ahk, nothing fancy like python
-
Are you just wanting to take data from an existing database to another one or what? This description doesn't make much sense tbh
-
Are you just wanting to take data from an existing database to another one or what? This description doesn't make much sense tbh
Kind of, but it'd have to be some sort of custom ocr.
Here's an example:
(https://goemaw.com/forum/proxy.php?request=http%3A%2F%2Fwww.freeforex.co.uk%2Fwp-content%2Fthemes%2Ffreeforex.co.uk%2Fimages%2Fscreenshots%2Fava-fx-platform.gif&hash=7c174f2aaeb5b591ccaa73d9e0715a56b484dc48)
Say I have this forex program, my scraper program, and a database program. I want the sell data (49) of eurusd into my database. I hit execute in scraper, and it screenshots the forex program. I have image files of every possible number, say 1-99, call this the custom ocr. The scraper takes the screenshot and compares the sell region with the custom ocr, and matches the region with one of the 99 images (which would be the image of 49). Because it matches with 49, have it throw "49" into the database program.
Actually I can already kind of so this with sikuli, a macro automation thing, but it is very slow...need this instant.
-
Aside from the fact this is a true Windows XP program, you are gonna need to pay someone to upgrade this thing.
-
I thought kstaters would be good at this stuff being good at engineering and all that :dunno:
-
Much easier to use raw data.
https://en.m.wikipedia.org/wiki/List_of_financial_data_feeds
-
Can't be raw data. That's just an example.
-
Or is ksu being good at engineering like mechanical or something like that? Seems more prole than I thought :dunno: