Create A PHP Header Redirect

To setup a simple redirect in PHP you will need to create a header() function. Simply create a index.php file in the location you want to redirect from with the following line of code: When linking…

Smartphone

独家优惠奖金 100% 高达 1 BTC + 180 免费旋转




Getting started with AWS RDS and PostgreSQL

AWS or amazon web services is a subsidiary created by Amazon itself for helping the tech companies, developers by providing lots of cloud computing, data storing, data warehouse to handle a large number of queries, etc. Big companies are now shifting to AWS so that they can perform cloud works on it for reliable and trusted support.

AWS RDS is a service provided by AWS for RDBMS (ex. MySQL, PostgreSQL). In the case of software development if software needs constant database support and also from remote, then RDS comes handy. One can create the database in RDS and then use that database from anywhere in the world using the internet as the database remains online 24/7 with very high uptime.

Now let's see how we can create a PostgreSQL in AWS RDS very easily within 5–6 min time. Plus how we can make the DB public on the internet.

Now in the services search box search for RDS.

Service Search Box
Search Result

Select RDS from the search result which says managed relational database service.

Now press “Create database” to start creating the database and wait for the next page.

From the “Engine options” select PostgreSQL and then choose the desired version that you need from the “Version” drop-down menu.

From the “Template” option choose “Dev/Test” if you want to make this database for testing purposes. However, you can choose “Production” when your software is ready to use and you want to use a database for the software(s) you are going to launch.

Choosing the right template.

From the “Settings” option, you first need to give your database a name. It can be any name for testing purposes. However, try to give a meaningful name for the “Production” version. Here, I have used “test-database” as my database name. After that, you need to provide a “Master username”. As I was saying before, it can be any name. Finally, you have to give a “Password” for your “Master username”.

The next part is “DB instance class”. From the checkboxes, you can select “Burstable classes” for low-tier usage. However, for production-level usage, one can use “Standard classes” and “Memory-optimized classes”.

From “Storage”, select the “Storage type” as per need. You can choose how much storage you need from “Allocated storage”. You can enable “Enable storage autoscaling” if you think that the storage capacity that you have put in the “Allocated storage” might be fully used. In that case, this option will help you to get extra storage when your “Allocated storage” limit exceeds. Good thing is, you can also type threshold as needed from “Maximum storage threshold”. For example, If you choose 20 GiB for “Allocated storage”, you have enabled the “Enable storage autoscaling” option and you have set the “Maximum storage threshold” to 1 GiB, then when 20GiB becomes full you will 1 extra GiB for future use.

Now for the connectivity part as we need to access this DB from anywhere in the world so we definitely need to consider this step carefully so that it doesn’t get anything wrong in the process.

Default Connectivity

Choose yes for the “Public access” field otherwise, the DB won’t be available in the internet. keeps everything as they are in default. 😁

The next step keep password authentication enabled.

Finally, create the database and wait it will take some time

And then it will be available to access from the database dashboard.

Click to open your newly created database. It will open into a new page.

The endpoint will be the host address to use to connect with the database. we need to add some inbound rules which will allow us to connect the DB from anywhere from the internet.

Press the above-marked permalink it will take you to security groups.

press the above-marked permalink and it will take you to a page from where you will be able to add inbound rules.

N.B: This is the most important part without this rule you will not be able to access your database through the internet.

How to use this host and connect with python you can read it here

Add a comment

Related posts:

Custom Manipulator Simulation in Gazebo and Motion Planning with MoveIt!

State-of-the-art robotics applications require tedious testing beforehand. As we all know now, simulations provide great value for the rapid prototyping that facilitate testing process in its…

Hand of Law

I had the record first. First I tell you! By many months, and considering when people finally found out how great it was — by many many years. And it played a role. It was at the very core of one of…

17.01.18

Viver em um mundo onde exista somente um lado correto é desequilíbrio e, esse desequilíbrio leva ao sofrimento. Ambos lados podem ter seus pontos negativos e positivos, que trazem lucidez ou…