![]() Say for this example we set the password to: “DataScienceRocks”. When installing we are asked to provide a password, just remember it as we need it later. Besides R and RStudio we need to install PostgreSQL, that we find here. Installing software, Starting the Server and Setting up new Usersįirst, we need to install the necessary software. One possible way to do it is to rent Amazon server, however, as I don’t have a budget for my projects and because I only need the data on my own machine I wanted to set up a server on my Windows 8.1 machine. While MySQL is the more widely used, PostgreSQL has the advantage of being open source and free for all usages. One solution is to use an SQL-based database, where I can query data in smaller chunks, leaving resources for the computation. Although 5 GB fit into my RAM the data uses a lot of resources. For example, recently I was facing a financial dataset of 5 GB. When dealing with large datasets that potentially exceed the memory of your machine it is nice to have another possibility such as your own server with an SQL/PostgreSQL database on it, where you can query the data in smaller digestible chunks. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |