アプリ関連ニュース
- 2020年4月13日
- 技術情報
CORS(cross origin resource sharing)
Today I will talk about cors , cross origin resource sharing. What its exactly and how we can handle it.
“CORS” stands for Cross-Source Resource Exchange. It allows you to make requests from one website to another website in the browser, which is normally prohibited by another browser policy called Same Source Policy (SOP).
You also have to know about SOP, same origin policy. CORS and SOP are browser policies that have been developed in response to security issues and browser vulnerabilities.
The browser-specific vulnerability that the Same Source Policy is intended to address is called “cross-site request forgery” (CSRF). The easy fix was for browsers to detect when a request is made from one website to another and prevent the response from being readable. This is the Same-Origin Policy.
Web servers that want to support CORS requests must respond to preflight requests with the following HTTP headers:
Access-Control-Allow-Origin: the whitelist origin, or “*”
Access-Control-Allow-Methods – A comma-separated list of HTTP methods that the web server wants to allow for cross-origin requests
Access-Control-Allow-Headers – A comma-separated list of HTTP headers that the web server wants to allow for cross-origin requests
By Yuuma.
yuuma at 2020年04月13日 11:00:47
- 2020年4月10日
- 技術情報
Laravelの開発環境構築方法(その2)
nishida at 2020年04月10日 10:00:54
“Sidecar”を使ってみよう
tanaka at 2020年04月08日 10:00:47
- 2020年4月06日
- 技術情報
SQL vs NoSQL
Today I will talk about sql versus nosql with some key details as below.
- Language
- Scalability
- Structure
- Support and some other interesting facts.
Language
SQL databases define and manipulate the data-based structured query language (SQL). SQL requires that you use predefined schemas to determine the structure of your data before working with it. Furthermore, all your data must follow the same structure. This may require a significant increase -Front preparation, which means that a change in the structure would be difficult and detrimental to the entire system.
A NoSQL database has a dynamic schema for unstructured data. The data is stored in many ways, which means it can be document-oriented, column-oriented, graphical, or organized like a KeyValue store. This flexibility means that documents can be created without having defined them. build first. Furthermore, each document can have its own unique structure.
Scalability
In almost all situations, SQL databases are vertically scalable. This means that you can increase the load on a single server by increasing things like RAM, CPU, or SSD. But, on the other hand, NoSQL databases are horizontally scalable. This means that it handles more traffic by fragmenting or adding more servers in its NoSQL database. Therefore, NoSQL can become larger and more powerful, making these databases the preferred choice for large or ever-changing data sets.
Structure
SQL databases are table-based, on the other hand, NoSQL databases are key-value pairs, graphical or document-based databases, or wide column warehouses. This makes relational SQL databases a better choice for applications that require multi-row transactions, such as an accounting system, or for legacy systems that were created for a relational structure.
Support
Great support is available for all SQL databases from your providers. There are also many independent queries that can help you with the SQL database for large-scale deployments, but for some NoSQL databases you still have to rely on community support and there are only limited external experts available to configure and implement your NoSQL large-scale deployments.
So what you should choose ? SQL or NoSQL ?
The best way to determine which database is right for your business is to analyze what its functions need. SQL is a good choice for any organization that benefits from a predefined structure and established schemas, particularly if they require multi-row transactions. It is also a good option if all data must be consistent without leaving room for error, as in accounting systems.
NoSQL is a good option for those experiencing rapid growth without clear schema definitions. NoSQL offers much more flexibility than a relational database and is a solid choice for companies that must analyze large amounts of data or whose data structures they manage are variable.
By Yuuma
yuuma at 2020年04月06日 11:00:12
- 2020年4月03日
- 技術情報
Laravelの開発環境構築方法(その1)
nishida at 2020年04月03日 10:00:10