|
Thread Rules
1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution.
2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20)
3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible.
4. Use [code] tags to format code blocks. |
On August 03 2016 09:41 ShoCkeyy wrote:
NO! Learn Python, the market is asking for more Python developers all the sudden. As for RoR, the syntax and conventions are bizarre, if someone else need to pickup the RoR app it's overkill... Python on the other hand, is very similar to JS, Java, and some what C++
I don't understand where you're coming from here. I think it's really location dependent in terms of job market for Python. I've done python web programming in Flask and Django and I don't think it's any better then Rails - I think Rails has a lot going for it in a lot bundled in, many gems, and a decent market of RoR dev. For example when I was in socal I could find a lot of RoR job posting but less Python work. Now I'm in SF and there's a ton of both. Also the "Rails Tutorial" which has been mentioned here before I'm sure is, I think, a solid intro into web development as a whole. I'm ntot sure what conventions from Rails you consider bizarre?
Python sure has a lot of other uses outside web such as in data analysis/machine learning (scipy, numby, pyspark, theano, tensorflow bindings) nowadays though.
On August 03 2016 16:25 kanu_knl wrote:
Hi, I am building a database for a non-profit school and is looking for mysql hosting companies. Do you know any good one? Thanks alot.
I thought Dreamhost was pretty reliable when I was doing lamp stack stuff. I'd avoid using AWS minus maybe RDS b/c I don't think if you're asking this question you should run your own linux server and deal with backups to be frank.
What are you trying to make for this school out of curiosity?
On August 03 2016 00:53 Doodsmack wrote:Show nested quote +On July 23 2016 01:14 enigmaticcam wrote:On July 22 2016 08:16 tofucake wrote:On July 22 2016 02:36 Doodsmack wrote:
Are Microsoft SQL Server skills (including T-SQL obv) valuable and future-secure? no Good to know, and there will always be MSSQL jobs, but Linux servers are like 98% of the internet That depends on how you use SQL server. Your typical DBA manages a SQL server mostly at an infrastructure level, which would all be proprietary to Microsoft. But at an application level, learning to collate data and understand how to talk to a database is absolutely relevant regardless of the language or implementation. Also not all databases support internet based applications. There are a lot of internal applications in the corporate world that require a database layer, and SQL Server thrives there. Thanks for the info all. I only have a basic understand of all this but what are some database technologies that may be used more for internet based applications (including cloud because I know there's Azure SQL). Are these technologies relational? I am learning T-SQL and feel pretty comfortable querying a relational db.
Some relational database (such as SQL server) plus a caching layer (for a lot of web companies, redis and memcache are often used to cache) can power a lot. Beyond just general fortune 500 business whose backend are powered by MSSQL/Oracle, some sites that come to mind are Stack Overflow and Plenty of Fish that have some public posts about their architecture.
+ Show Spoiler +
Some alternative relational databases you'll see mentioned a lot on the internet are MySQL (and it's corresponding forks MariaDB, Percona) and Postgres. These are relational db server that are suitable for a decently high throughput internet application and an OLTP workload.
All these databases support various levels of SQL standard and have different features but they all provide basic compatibility for a lot of CRUD functionality. For example SQL server supports materialized views which neither Postgres or MySQL do, and MySQL doesn't have stuff like common table expressions. "use the index luke" is a fun side to read some of their articles.
There's document DBs such as couchdb and mongo as Mantiou mentioned. Broadly, relational databases have support for...relations among tables with foreign keys. Document DBs focus on having large denormalized documents and don't support relations - in turn they tend to buy things such as maybe more scability, ease of multimaster setup. I've not used CouchDB but I've used mongodb and regret all the pain it's caused me to be honest - a lot of times we moved logic into app to deal with funky data. Since you mention TSQL I assume you're in .NET world - there is RavenDB there as a document DB.
Beyond that there are a wealth of other DB with different use cases you might run into all in one company. There's wide column stores such as Cassandra that will buy you very high write throughput and linear scalability across nodes but now you have to structure your data partitions. For example, Apple runs a very large Cassandra cluster - perhaps iMessage metadata per user. HBase is an alternative here.
There is the whole Hadoop ecosystem of HDFS, Hadoop, Hive, Presto, Drill etc - basically Hadoop map reduce and tools around quickly gaining insights out of that (so not everyone has to write their own map reduce jobs). You might run into this working in a lot of companies analytics pipelines, even normal bigco fortune 500 work now. In the analytics space you run into other proprietary column stores such as Vertica, Teradata, Hana which are optimized for OLAP analytics queries.
To some extent you can get away with only a single MySQL/Postgres instance and in my opinion knowing how to work well with relational data is super important base skill to have.
I've worked at 2 companies doing internet facing stuff and can share a bit about the technolgies they used
First company was just bigco and I worked in team that was responsibile for operation of main website where people bought products and paid bills:
1) Lots of oracle and MSSQL clusters that power various frontend web and desktop apps
2) Java datagrid as cache (Oracle coherence)
3) Some MySQL clusters for low throughput web apps, Varnish as caching in front of this.
4) DB2 instance
5) Teradata and Hadoop used for the analytics in the departments I knew about.
6) Elasticsearch for logging data clusters
7) Using berkeleydb ldap for some stuff
At other company (web facing)
1) User data in mongo (sadness)
2) Main system uses heavily cached mongo, cassandra for handling several k request/sec
3) Feed data via Kafka into Hive for analytics
4) Analytics rolled up into MySQL via jobs for report
|
Great post!
I agree with the pain of using mongodb. I'm using it to store a lot of data from the dota2 api, and that's fine but as soon as I want to do something with it it's, well awful.
The query, "Delete everything (not in this list and older than 7 days)" is a pain to run. It got translated to 100 lines of python code because of limitations in mongo (2.6).
Also, postgresql does have support for materialized views https://www.postgresql.org/docs/9.5/static/rules-materializedviews.html
CREATE MATERIALIZED VIEW mymatview AS SELECT * FROM mytab;
REFRESH MATERIALIZED VIEW mymatview;
|
On August 04 2016 18:07 Prillan wrote:Great post! I agree with the pain of using mongodb. I'm using it to store a lot of data from the dota2 api, and that's fine but as soon as I want to do something with it it's, well awful. The query, "Delete everything (not in this list and older than 7 days)" is a pain to run. It got translated to 100 lines of python code because of limitations in mongo (2.6). Also, postgresql does have support for materialized views https://www.postgresql.org/docs/9.5/static/rules-materializedviews.htmlCREATE MATERIALIZED VIEW mymatview AS SELECT * FROM mytab;
REFRESH MATERIALIZED VIEW mymatview;
Good catch, thanks! What I meant to say is in MSSQL and Oracle you can have materialized views that are automatically updated when the backing tables change. In Postgres and MySQL you can do the same with triggers I suppose I just have never done it.
|
On August 05 2016 04:17 teamamerica wrote:Show nested quote +On August 04 2016 18:07 Prillan wrote:Great post! I agree with the pain of using mongodb. I'm using it to store a lot of data from the dota2 api, and that's fine but as soon as I want to do something with it it's, well awful. The query, "Delete everything (not in this list and older than 7 days)" is a pain to run. It got translated to 100 lines of python code because of limitations in mongo (2.6). Also, postgresql does have support for materialized views https://www.postgresql.org/docs/9.5/static/rules-materializedviews.htmlCREATE MATERIALIZED VIEW mymatview AS SELECT * FROM mytab;
REFRESH MATERIALIZED VIEW mymatview; Good catch, thanks! What I meant to say is in MSSQL and Oracle you can have materialized views that are automatically updated when the backing tables change. In Postgres and MySQL you can do the same with triggers I suppose I just have never done it.
You can have regular views in postgres which act pretty much like aggregate queries and are always up to date.
|
How is your math guys? I've found mine is lacking. Any suggestions how to improve? E.g. books to self-educate myself.
|
GRAND OLD AMERICA16375 Posts
|
On August 05 2016 05:31 Shield wrote:
How is your math guys? I've found mine is lacking. Any suggestions how to improve? E.g. books to self-educate myself.
Khan academy imo. Mine is good, I was pretty good at math through out high school, always two grades ahead in math than my peers. I know for Javascript, Algebra does wonders 
On August 04 2016 16:15 teamamerica wrote:Show nested quote +On August 03 2016 09:41 ShoCkeyy wrote:
NO! Learn Python, the market is asking for more Python developers all the sudden. As for RoR, the syntax and conventions are bizarre, if someone else need to pickup the RoR app it's overkill... Python on the other hand, is very similar to JS, Java, and some what C++ I don't understand where you're coming from here. I think it's really location dependent in terms of job market for Python. I've done python web programming in Flask and Django and I don't think it's any better then Rails - I think Rails has a lot going for it in a lot bundled in, many gems, and a decent market of RoR dev. For example when I was in socal I could find a lot of RoR job posting but less Python work. Now I'm in SF and there's a ton of both. Also the "Rails Tutorial" which has been mentioned here before I'm sure is, I think, a solid intro into web development as a whole. I'm ntot sure what conventions from Rails you consider bizarre? Python sure has a lot of other uses outside web such as in data analysis/machine learning (scipy, numby, pyspark, theano, tensorflow bindings) nowadays though.
If you're trying to say RoR is good for the gems, community, then why not just use Node? Which is 10x better at this point.
As for the conventions, devs often ignore learning conventions properly, and it creates a mess within apps. This is typical case when I used to find RoR developers, they ignore it because rails does a lot of magic.
http://stackoverflow.com/questions/441717/whats-wrong-with-magic
|
28100 Posts
I haven't checked out Khan academy in a while, but I think it stops at basic Uni calculus and linear algrebra? So if you haven't gone that far it's great, but otherwise it's a bit lacking.
|
On August 05 2016 06:20 TheEmulator wrote:
I haven't checked out Khan academy in a while, but I think it stops at basic Uni calculus and linear algrebra? So if you haven't gone that far it's great, but otherwise it's a bit lacking.
It covers most math through the first two years of university in the states, for an average student. It's not a phenomenal resource, but considering it's free I'd say that it's still exceptional for >75% of people.
|
28100 Posts
Oh kk. I thought it just covered high school calc and some of uni calc I, then some basic linear stuff.
|
On August 05 2016 06:47 TheEmulator wrote:
Oh kk. I thought it just covered high school calc and some of uni calc I, then some basic linear stuff.
Nah, it covers calculus through multivariable integration and some basic vector calculus. It also covers linear algebra and basic diffEqs. It basically covers the average engineer's mathematics sequence I think.
|
We use hystrix. If you're going to use it though and you're using it for http I'd suggest using feign though. It's all the good of hystrix but wrapped a bit nicer.
|
On August 05 2016 06:05 ShoCkeyy wrote:
If you're trying to say RoR is good for the gems, community, then why not just use Node? Which is 10x better at this point.
Dude, but Node is JavaScript and JavaScript is:
a) bad
b) not something I'd feel comfortable running in the back-end
We've been checking various technologies at my company recently to switch out of PHP. Compiled pros and cons for most common things and what cracked me was the consensus for 2 things among 90% of our developers:
1. Main JS con: JavaScript
2. Main Java con: Java
|
On August 05 2016 16:15 Manit0u wrote:Show nested quote +On August 05 2016 06:05 ShoCkeyy wrote:
If you're trying to say RoR is good for the gems, community, then why not just use Node? Which is 10x better at this point.
Dude, but Node is JavaScript and JavaScript is: a) bad b) not something I'd feel comfortable running in the back-end We've been checking various technologies at my company recently to switch out of PHP. Compiled pros and cons for most common things and what cracked me was the consensus for 2 things among 90% of our developers: 1. Main JS con: JavaScript 2. Main Java con: Java
Why are your developers this stupid (I don't know how not stupid your developers are, except for that 55 year old intern who "downloaded a bunch of zipfiles" from github). I can understand the "Main JS con: JavaScript" but "Main Java con: Java" is plain bs.
Anyway, ask your developers what Main Scala con is. Or Main Python con. Or Main Golang con.
|
|
|
On August 05 2016 16:31 Djagulingu wrote:Show nested quote +On August 05 2016 16:15 Manit0u wrote:On August 05 2016 06:05 ShoCkeyy wrote:
If you're trying to say RoR is good for the gems, community, then why not just use Node? Which is 10x better at this point.
Dude, but Node is JavaScript and JavaScript is: a) bad b) not something I'd feel comfortable running in the back-end We've been checking various technologies at my company recently to switch out of PHP. Compiled pros and cons for most common things and what cracked me was the consensus for 2 things among 90% of our developers: 1. Main JS con: JavaScript 2. Main Java con: Java Why are your developers this stupid (I don't know how not stupid your developers are, except for that 55 year old intern who "downloaded a bunch of zipfiles" from github). I can understand the "Main JS con: JavaScript" but "Main Java con: Java" is plain bs. Anyway, ask your developers what Main Scala con is. Or Main Python con. Or Main Golang con.
We tried Java in one project and no one liked it. Also, why would you use Java if you can use Scala, Clojure, JRuby, Jython or anything else that compiles to Java bytecode, can run on JVM and gives you access to all of Java without the horrible thing that is Java itself?
Edit: A bit further explanation...
I've been trying to get into Java for years now (off and on) and I simply can't do it. I mean, I could code in it if I was forced to, but it would give me 0 pleasure and my mindset is that I do what I do because it's fun and I like it (earning money is just a byproduct of doing something I'd be doing anyway). Java is no fun for me, it would feel like work...
|
Hyrule19221 Posts
JS isn't bad, it's actually amazing. But it's bad for backend. Java is also bad for web but not bad intrinsically.
|
|
|
Yes, if you say it's bad, then you're not using JavaScript correctly. While it does have its issues, it has come a long way. Never ever use it for math that's for damn sure.
|
On August 05 2016 21:55 ShoCkeyy wrote:
Yes, if you say it's bad, then you're not using JavaScript correctly. While it does have its issues, it has come a long way. Never ever use it for math that's for damn sure.
Don't forget about Date, which isn't even consistent across browsers.
|
|
|
|
|
|
EPT
