Part 2 - Web DevelopmentYouTube↗  IA↗(long shot)
Education  643 views 2 likes 0 dislikes   07 May 2012
Udacity 651K subscribers United States YouTube↗


Please select the problem
You must specify your email and describe the problem in detail
Describe your problem in detail if it's not obvious

Click to Play Video Click to Play Video
okay so with this office hours we had a lot of questions about my sequel and
MySQLとPostgreSQLについて[br]たくさん質問をもらっています
post grads and why you prefer postgrads to my sequel why other people prefer my sequel all at a time so if you could
なぜMySQLの人気が高いのですか？[br]あなたはなぜMySQLよりPostgreSQLを好むのですか？
answer some of those it'd be great yes
質問に答えてもらえますか?
yes so we'll start the first question which is why i prefer postgres over my
順番に答えましょう[br]なぜ私はPostgreSQLが好きなのか？
sequel and this is a two-part answer
2つの答えがあります
back in 2005 when we started reddit I was I was basically where you are now
Redditを始めた2005年[br]私はアプリケーションの仕事を
which is just learning how web apps work
学び始めたばかりの初心者でした
and I was trying to install all this stuff on my computer and I started
私はMySQLとPostgreSQLを自分のPCに[br]インストールしました
installing my sequel in Postgres and my sequel wouldn't compile on my mac and postcards would so that's good reason
MySQLは私のMacとコンパイルできず[br]PostgreSQLはできたのが理由です
well I mean actually to be fair it says
これはプロジェクトによるところが大きいのです
a lot about a project like if it built on my Mac it'll probably build just
私のMacで構築されたものは[br]どこでも同じだったでしょう
about anywhere because at the time what sex was still fairly new um so that's
当時OSXはまだかなり新しかったのです
how we started with postgres my sequel
それがPostgreSQLで始めた理由です
at the time was still very popular it's
当時のMySQLはPostgreSQLに比べ[br]はるかにポピュラーでしたが
far more popular in Postgres but it had a reputation for being a little lossy
データに不可逆性があると言われていました
with data this is maybe the right word a little inconsistent postgrads the
少し矛盾があるというのが正しい表現かもしれません
documentation was better the they were they would sacrifice you know kind of
PostgreSQLはドキュメンテーションはいいのですが[br]安定性と一貫性と忠実性の機能を
functionality over stability and consistency and and adherence to kind of a sequel standard and some queries that
SQLのスタンダートに比べ[br]犠牲にしている部分がありました
we did on reddit that kind of pushed the limits of these databases ran much much
Redditで行ったクエリは[br]データベースの限界に挑戦しましたが
faster and post guards down on my sequel so I've just been loyal ever since these
MySQLよりPostgreSQLの方が速くて動きもよいので[br]それ以来PostgreSQL一筋です
days feature for feature they're
今は機能面では基本的に同じです
basically the same my sequel is not nearly so you know I'll go there with you have and a lot of people use my
MySQLはデータに関心を払っていますし
sequel so at this point it's whichever
多くの人がMySQLを利用します
you prefer maybe go back to whichever
あなたがどちらを好んでも
compiles easier on your computer is a
自分のPCにコンパイラしやすいという点が
perfectly acceptable reason these days I
選択の大きなポイントになるでしょう
think okay we also had some questions about other types of databases why no
他のデータベースについての質問もきました
sequel databases were popular why a lot of companies are moving to that you
NoSQLデータベースはなぜ人気なのか？[br]多くの企業が移行していますよね
mentioned that Facebook uses my sequel I
確かFacebookはMySQLを使ってると言ってましたね
believe and we had some questions about them using no sequel as well okay sure
NoSQLについて教えてください
so yeah no sequel is basically a reaction to the difficulties of developing with sequel databases one of
NoSQLはSQLを使って開発する[br]困難に対抗するためにできました
the challenges with sequel databases is you have to define your tables ahead of
SQLデータベースの課題は最初にテーブルを[br]定義する必要があることです
time you have to know what your columns are going to be you have to know what
どのようなサイトになるのか知らなければなりません
the types but when you're writing a web software one of the advantages of writing web
Webソフトウェアで書く利点の一つは
software is you don't have to think everything through an advance you can
前もってすべてを考える必要がないことです
get something working you can put it online you can see all users react to it
作業しながら[br]オンライン上でユーザの反応も見られます
you can kind of iterate from there you know add new features take pictures weight and whatever you want to do the
機能の追加や削除を何度でも[br]好きなだけ繰り返すことができます
challenge is when you have databases and
課題は膨大なデータをもつデータベースの場合
a large amount of data you have to sometimes you know add a new column or add a new index or you know add a bunch
新しいコラム、インデックス、データタイプ型などの[br]追加が必要になることです
of new data types when you have a database in production that has thousands or millions of users this can
数千 数万のユーザを抱えるデータベースの作業は
be really painful so these no sequel
非常に困難なものになります
databases generally they try to solve
NoSQLはこの問題の解決を試みています
that problem they make it another way to describe that would be schema list
スキーマレスデータベースという方法です
databases the database don't have a
データベースにスキーマがないのです
schema that is they don't have a formal description of columns and data types and it's neat on reddit we kind of built
コラムとデータタイプの形式記述を持たないのです
our own kind of scheme Ellis system on
RedditではPostgreSQL上で[br]スキーマレスレスのシステムを構築しました
top of postgres and we actually do the same thing again at hit mom because it's
Hipmunkも同様です
a nice way of working the challenge
作業がやりやすいのです
right now a lot of these scheme Ellis databases is they're not very good you
現在の課題は多くのスキーマレスの[br]データベースはあまり良くないことです
know they are there they're brand new technology databases are really hard so
新しいテクノロジですからね[br]データベースはとても困難な分野です
they have stability problems they you know documentation is lacking you know
安定性の問題やドキュメンテーションの欠陥があります
that there's not very many of them are used in the wild and production so you
少ないですがウイルスに感染している場合もあります
don't have kind of you know good support and people to lean on that sort of thing
良いサポートも頼れるような人もいないのです
so in my opinion it's still wise especially when it comes to data
データに関しては特にNoSQLは非常に優秀です
especially if you care about your data to stick with something that's proven
もしあなたがデータに関心があり[br]実証済みにこだわるなら最適です
that works that you know how to scale
スケールアップの方法も分かります
you know everybody's worked with postcards of my sequel for a long time
多くの人が長い間PostgreSQLとMySQLで[br]作業をしてきました
now so those things worked very very
これらはとてもいいです
well now as for facebook they used I don't work at Facebook so I'm not
私はFacebookで働いたことはないので[br]自信はありませんが
necessarily not 30 on this subject but I
彼らはMySQLを使っていたはずです
know they use a lot of my sequel they've actually made a lot of improvements to
MySQLの改善もたくさん行って
my sequel and they also wrote their own no sequel system called Cassandra which
Cassandraという独自のNoSQLシステムも作りました
my understanding although I don't know for sure is they don't actually use
今はもう使っていないようです
anymore ready use this cassander incidentally they started using that after I left however and I can't say
そういえば私が辞めてからRedditは[br]Cassandraを使っています
with the clear conscience that I condone
その決定について容認しているとは明言できませんが
that decision but apparently it's working for them in production so you
明らかに制作のために使われています
know your mileage may vary personally I
私はPostgreSQLに満足しています
i'm happy with postgres i know how to scale at these days and you can you can get away with kind of scheme Ellis
大きなJSONデータの塊のような[br]一つの列をストアすることにより
behavior in Postgres by just storing you know one column that's like a big wad of JSON for
スキーマレスのデータを[br]PostgreSQLでうまく扱うことができます
example that actually works really well depending on what problem is you're
解決したい問題によっては有効です
solving so anyway that's a long answer to a simple question but uh that that's that's that's that's my opinion okay great
シンプルな質問でしたが長い答えになってしまいました
Similar videos:

Locking and Memcache - Web Development
Udacity
5.6K views 16 likes 0 dislikes 27 May 2012100% match

Making Links
Udacity
53.9K views 21 likes 0 dislikes 23 Feb 2015100% match

Introduction - Web Development
Udacity
2.1K views 2 likes 0 dislikes 23 Feb 2015100% match

Valid Receivers - Web Development
Udacity
2.6K views 1 likes 0 dislikes 23 Feb 2015100% match

Interview with Neil - Web Development
Udacity
4.5K views 16 likes 0 dislikes 23 Feb 2015100% match

Advanced String Substitution - Web Development
Udacity
5.5K views 1 likes 0 dislikes 22 Apr 2012100% match

Dynamic Content - Web Development
Udacity
6.1K views 2 likes 0 dislikes 23 Feb 2015100% match

Best Browser - Web Development
Udacity
14.9K views 7 likes 0 dislikes 23 Feb 2015100% match

Making Requests - Web Development
Udacity
5.8K views 10 likes 0 dislikes 23 Feb 2015100% match

More Handlers Solution - Web Development
Udacity
2.4K views 10 likes 0 dislikes 22 Apr 2012100% match

The Action Attribute - Web Development
Udacity
2.6K views 6 likes 0 dislikes 22 Apr 2012100% match

What Is a Database? - Web Development
Udacity
2.4K views 0 likes 0 dislikes 25 Apr 2012100% match

Code Organization - Web Development
Udacity
7.2K views 25 likes 1 dislikes 27 May 2012100% match

Port Solution - Web Development
Udacity
5K views 2 likes 0 dislikes 23 Feb 2015100% match

Content Type - Web Development
Udacity
7.5K views 5 likes 1 dislikes 22 Apr 2012100% match

Build a Wiki - Web Development
Udacity
3.2K views 3 likes 0 dislikes 27 May 2012100% match

The Method Attribute - Web Development
Udacity
9.6K views 14 likes 8 dislikes 22 Apr 2012100% match

Spam Prevention - Web Development
Udacity
4.2K views 26 likes 2 dislikes 27 May 2012100% match

Problems with Get - Web Development
Udacity
3.3K views 15 likes 2 dislikes 22 Apr 2012100% match

Querying Links - Web Development
Udacity
2K views 1 likes 0 dislikes 25 Apr 2012100% match

Course Outline - Web Development
Udacity
46.2K views 169 likes 0 dislikes 23 Feb 2015100% match

Methods and Parameters - Web Development
Udacity
4.3K views 1 likes 0 dislikes 22 Apr 2012100% match

Most Common Method - Web Development
Udacity
9.7K views 5 likes 0 dislikes 23 Feb 2015100% match

Paragraph Tag - Web Development
Udacity
8.6K views 4 likes 0 dislikes 23 Feb 2015100% match

Next Steps - Web Development
Udacity
2.3K views 5 likes 0 dislikes 27 May 2012100% match

Precomputed Caching - Web Development
Udacity
12.2K views 80 likes 0 dislikes 27 May 2012100% match

HTTP Responses - Web Development
Udacity
5.5K views 19 likes 0 dislikes 23 Feb 2015100% match

Response Headers - Web Development
Udacity
6.4K views 21 likes 4 dislikes 23 Feb 2015100% match

Entering Input - Web Development
Udacity
6.3K views 3 likes 0 dislikes 22 Apr 2012100% match

Valid Day - Web Development
Udacity
3.2K views 1 likes 0 dislikes 22 Apr 2012100% match


Settings Privacy About Contact Donate