投稿時間:2022-03-20 22:15:48 RSSフィード2022-03-20 22:00 分まとめ(17件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
js	JavaScriptタグが付けられた新着投稿 - Qiita	3Dの散布図をさくっと見るツールを作ってみた	https://qiita.com/yo16/items/b5af6d2e9d1bf5e8ab51	透過しないとかそういう細かい工夫を積み重ねるんだろうなとは思いますが、今回の目的は「さくっと点群が見たい」だし、初心者なのでスルーさせていただきました。	2022-03-20 21:35:39
海外TECH	DEV Community	Web development	https://dev.to/torine6/web-development-1g3p	Web developmentWhat is web development Web development is the task of developing websites that can be hosted by the internet Web development varies from a simple page to complex websites Why Python for web developmentPython is flexible and easy to use Python is very stable hence it helps to dynamically build web applications Python provides quick processing Python is an all in one tool Different types of web development Front end web developmentThe front end is the part that is loaded inside a web browser on a client machine The front end is the part that the user sees and interacts with Front end web development is responsible for how a website looks or feels Back end web developmentThe back end is the part that runs on a web server The back end is responsible for data processing validating business rules etcBack end web development is responsible for building and maintaining the code that runs a website Full stack web developmentFull stack web development is development of both the front end client side and back end server side of a web application Full stack developers are experts that cover both front end and back end responsibilities Basics for building web applicationsi Address URLURL refers to Uniform Resource Locator It is a way to relocate a resource on the internet A resource can be a web page image video or a pdfii HTTPHTTP refers to Hypertext Transfer Protocol Data exchange between back end and front end is determined by protocol called HTTP HTTP defines how clients and servers can communicate iii HTMLHTML refers to Hypertext Markup Language HTML is a simple language for presenting web pages and their content Web pages are built using HTML When using HTML the server responds to the client by generating the requested page and returns it to the client The other option is to return the data needed by the client and have the client generate the page This is considered the industry best practice iv APIAPI stands for Application programming Interface API is a software intermediary that allows two applications to interact with each other Modern APIs adhere to HTTP standards that are developer friendly easily accessible and understood broadly Libraries Python provides for web developmentCherryPyDjangowebpyPyramidTurboGearsFlaskRecommended libraryFor a beginner I would recommend using Django Django is a high level Python framework used for building web applications Django is used for back end web development Why Django Django is best for web development for beginners because i Django is written purely in Python ii Django is fast you can create websites within few hours iii Django is fully loaded with all tools to create websites iv Django is very secure Django featuresAdmin site an automatically generated user interface fo Django models ORM Object relational mapper gt allows developers to interact with the Django database Authentication gt verifies the user and determines what the verified user can do Caching gt lets the server process a request and store it in our cache Examples of applications that rely on DjangoYouTubeQuoraGoogleInstagramBitlyDropboxSpotifyResources Web development in Python YouTube videoIf there s one thing you learn by working on a lot of different websites it s that almost any design idea no matter how appalingly bad can be made usable in the right circumstances with enough effort Steve Krug	2022-03-20 12:46:11
海外TECH	DEV Community	SQL DDL Commands	https://dev.to/baransel/sql-ddl-commands-2p94	SQL DDL CommandsSign up to my newsletter What is SQL DDL Data Definition Language DDL deals with the type of data in the database In other words we do all of these with DDL what will be the relations between the tables in the database and the types of data in the table DDL basically consists of three commands CREATE Used to create objects Table Database etc ALTER It is used to modify objects DROP Used to delete objects CREATE COMMANDIt is used to create database and database objects What are database objects TableA collection of rows with related columnsConstraintsIt imposes restrictions on values contained in columnsIndexProvides fast access to dataViewProvides access to information from one or more tables or viewsStored ProcedureA set of SQL commandsTriggerA set of SQL commands that are automatically executed when the user makes a change on the information A kind of stored procedure In this article we will create databases and tables that are database objects Create DatabaseCREATE DATABASE database nameAnd this usage is the same for all database management systems CREATE DATABASE baranselLet s see if the database has been created As you can see we have created the baransel database Create TableBefore creating the table we need to specify on which database you will create the table For this The general usage is as follows use database nameuse baranselWe have specified on which database you will create it now let s create our table The general usage for this is as follows CREATE TABLE table name column name data type size column name data type size column name data type size It is used in the form Then let s create the students table as an example CREATE TABLE students student id int student name varchar student surname varchar student average grade float Let s explain what we did first we created a table named students then first we created a column named student id with data type integer in this database Then we added our other varchar data type columns here varchar states that it can take up to characters you can get any data length you want This is how to create a table in a basic simple way But we need to add some properties to this table for example student id must be different for each student so that I can distinguish them Primary Key ExpressionA primary key is used to make a field i e a column a unique value in a table What does this mean if there is a student with student id in the table you cannot add a second student with student id of Let s use it now CREATE TABLE students student id int primary key student name varchar student surname varchar student average grade float By typing a primary key next to the variable type we have informed that this column is a primary key that is a unique value Note Did you get an error like this Table students already existsDon t worry it gave an error because we created a table named students before Because table names are singular think of them as primary There cannot be more than one table with the same name in a database So let s delete our first table and run it again Now you have to ask me a question here If the student id number is not entered then how will we distinguish it That is if it fills in other fields and leaves the student id column blank In this case you cannot distinguish for this we must make the student id part mandatory Most of the time when registering on a site or a place you have received a warning that the username or email address cannot be blank Here we will warn the user that the student id cannot be empty Let s do it now CREATE TABLE students student id int not null primary key student name varchar student surname varchar student average grade float This is how we got it done The student id column is now both primary and not null so it cannot be left blank So is there anything missing No it s not over yet we got the student id part but we forgot to check something You have come across many times today just because you have to enter a character phone number or you will enter an exam score but you must enter a value between for the exam score Yes we should check that here For this Check StatementCREATE TABLE students student id int not null primary key check student id lt student name varchar student surname varchar student average grade float Yes we have stated here that our student id number can be max So should it give an error only when it is greater than ID number cannot be negative then we have to check more than one situation CREATE TABLE students student id int not null primary key check student id lt and student id gt student name varchar student surname varchar student average grade float We stated above that student id is primary cannot be empty and will be less than and greater than What if multiple columns have separate conditions For example if both columns need to be primary If columns need to be not null Should we write one by one Constraint StatementConstraint expression is the expression we will use when we control more than one column Let s show it with an example CREATE TABLE students student id int student name varchar student surname varchar student average grade float class no int constraint p key primary key student id class no Here we specified that the class no and student id columns are the primary key at the same time My request from you is to use the word constraint together with the check statement in the same way Finally let s show another expression Identity ExpressionIn some cases not ourselves but the id number etc We will want to add the columns automatically We will use the identity statement for this If you wish you can specify that adding to the table will be automatically added to the table with the IDENTITY statement This usage is used in the sense of starting from and continuing at intervals CREATE TABLE students student id int not null IDENTITY student name varchar student surname varchar student average grade float class no int constraint p key primary key student id class no ALTER COMMANDThis command which is change and update is used to update the tables Let s see our table first The ALTER command takes three different parameters ADDDROPMODIFY ADD This parameter allows us to add columns to the table ALTER TABLE table name ADD column name column propertyNow let s add a new column for example the date column ALTER TABLE students ADD date datetimeNow let s look at the final version of our table As you can see we have added the date column DROP With this parameter it allows us to delete a column from the table ALTER TABLE table name DROP COLUMN column nameNow let s delete a column in our table I m deleting the date column we just added ALTER TABLE students DROP dateThus the date column was deleted MODIFY Allows you to update the column specified in the table with this parameter ALTER TABLE table name MODIFY COLUMN column name column propertyNow let s make it text while the data type of the student name column on the table is varchar ALTER TABLE students MODIFY COLUMN student name text DROP COMMANDThis command is for deleting the database and tables we have created Database DeletionCommon usage for deleting an existing database DROP DATABASE baransel Table DeletionDROP TABLE studentsIn this way we learned database and table deletion operations Sign up to my newsletter	2022-03-20 12:45:59
海外TECH	DEV Community	Operators in JavaScript	https://dev.to/hardikmirg/operators-in-javascript-258e	Operators in JavaScript Operators in JavaScriptBasic OperatorsComparison OperatorsLogical OperatorsBitwise Operators Basic Operators Addition Subtraction Multiplication Division Modulus Increment Decrement Group Comparision Operators Equal Value Equal Value And Same Type Not Equal Value Not Equal Value And Different Type gt Greater Than lt Less Than gt Greater than and Equal to lt Lesser than and Equal to Logical Operators amp amp Logical And Logical OR Logical Not BitWise Operators amp AND statement OR statement NOT XOR lt lt Zero fill left shift gt gt Signed right shift gt gt gt Zero Fill right shift	2022-03-20 12:18:21
Apple	AppleInsider - Frontpage News	Top Deals March 20: $175 AirPods Pro, $43 Razer Kraken Headset, $390 Gigabyte Curved Monitor	https://appleinsider.com/articles/22/03/20/top-deals-march-20-175-airpods-pro-43-razer-kraken-headset-390-gigabyte-curved-monitor?utm_medium=rss	Top Deals March AirPods Pro Razer Kraken Headset Gigabyte Curved MonitorSunday s top deals include AirPods Pro for a SteelSeries Rival mouse for TB of WD EasyStore storage for and a Ryobi cordless tools combo for Every day we search high and low across the internet to find the best tech deals including discounts on Apple products tech accessories and a variety of other items all to help you save some money If an item is out of stock you may still be able to order it for delivery at a later date Many of the discounts are likely to expire soon though so be sure to grab what you can We re continuing to add new deals daily Be sure to check back regularly even on the weekend to check out all the newest deals we ve found Read more	2022-03-20 12:31:32
海外ニュース	Japan Times latest articles	Ukraine leader says siege of Mariupol ‘a terror that will be remembered for centuries’	https://www.japantimes.co.jp/news/2022/03/20/world/zelenskyy-peace-call/	Ukraine leader says siege of Mariupol a terror that will be remembered for centuries Some people have been trapped in Mariupol for more than two weeks sheltering from heavy bombardment that has severed central supplies of electricity heating	2022-03-20 21:11:36
ニュース	BBC News - Home	I will help with costs where I can, says Chancellor Rishi Sunak	https://www.bbc.co.uk/news/uk-politics-60812549?at_medium=RSS&at_campaign=KARANGA	faces	2022-03-20 12:43:51
ニュース	BBC News - Home	P&O Ferries' sackings were appalling, says Sunak	https://www.bbc.co.uk/news/business-60812328?at_medium=RSS&at_campaign=KARANGA	chancellor	2022-03-20 12:24:36
ニュース	BBC News - Home	Sabita Thanwani killing: Manhunt continues over Clerkenwell death	https://www.bbc.co.uk/news/uk-england-london-60811107?at_medium=RSS&at_campaign=KARANGA	sabita	2022-03-20 12:30:03
北海道	北海道新聞	上川管内で１１２人感染、旭川は７４人　新型コロナ	https://www.hokkaido-np.co.jp/article/659155/	上川管内	2022-03-20 21:25:36
北海道	北海道新聞	ぎょうざに合う１品、北星女子中生が考案　「みよしの」で期間限定販売へ	https://www.hokkaido-np.co.jp/article/659238/	北星学園	2022-03-20 21:23:00
北海道	北海道新聞	ウクライナから帰国の降籏さん旭川到着　妹との再会に涙	https://www.hokkaido-np.co.jp/article/659229/	世界大戦	2022-03-20 21:22:25
北海道	北海道新聞	中国、ＰＣＲ担当者が死亡　コロナ、現場負担増に懸念の声	https://www.hokkaido-np.co.jp/article/659235/	中国メディア	2022-03-20 21:21:00
北海道	北海道新聞	悪質自転車、対策強化へ　全国で集中取り締まり	https://www.hokkaido-np.co.jp/article/659237/	取り締まり	2022-03-20 21:18:00
北海道	北海道新聞	オートバイ、中上貴晶は１９位　世界選手権、インドネシアＧＰ	https://www.hokkaido-np.co.jp/article/659236/	世界選手権	2022-03-20 21:18:00
北海道	北海道新聞	ばんえい競馬の馬券発売額が初の５００億円超え	https://www.hokkaido-np.co.jp/article/659231/	馬券	2022-03-20 21:09:00
北海道	北海道新聞	原油市場の安定化へ連携確認　林外相、ＵＡＥ閣僚と会談	https://www.hokkaido-np.co.jp/article/659232/	首都	2022-03-20 21:08:00