Archivo del Autor: carlosap

3 handy command-line internet speed tests – bandwidth

Speedtest Speedtest is an old favorite. It’s implemented in Python, packaged in Apt, and also available with pip. You can use it as a command-line tool or within a Python script. Install it with: or Then run it with the command speedtest: $ speedtestRetrieving speedtest.net configuration…Testing from CenturyLink (65.128.194.58)…Retrieving speedtest.net server list…Selecting best server based on ping…Hosted by… Leer más »

How to Install MongoDB 3.2 on CentOS 7.x and RHEL 7.x

Step:1 Configure MongoDB 3.2 yum Repository. In both Operating system RHEL7.x and CentOS 7.x yum repositories are kept in ‘/etc/yum.repos.d/’ directory.  Create the mongodb repository file with the name “mongodb-org.repo”. [root@mongodb ~]# cd /etc/yum.repos.d/ [root@mongodb yum.repos.d]# vi mongodb-org.repo name=MongoDB 3.2 Repository baseurl=https://repo.mongodb.org/yum/redhat/$releasever/mongodb-org/3.2/x86_64/ gpgcheck=1 enabled=1 gpgkey=https://www.mongodb.org/static/pgp/server-3.2.asc Step:2 Install MongoDB package using yum command. To install MongoDB… Leer más »

Migrate Your SQLSERVER Data To MongoDB Using Mongify Utility

Install Ruby 2.5 gem list yum install freetds freetds-devel yum -y install nano wget gdbm-devel libdb4-devel libffi-devel libyaml libyaml-devel ncurses-devel openssl-devel readline-devel tcl-devel zlib-devel mysql-devel activerecord-sqlserver-adapter (4.2.0)mongify (1.3.2)tiny_tds (2.1.2) gem install activerecord-sqlserver-adapter -v 4.2

SYSTEM ERROR: -s exceeded error

SYSTEM ERROR: -s exceeded. Raising STOP condition and attempting to write stack trace to file ‘procore’. Consider increasing -s startup parameter. (5635) Edit startup.pf in progress install directory

Enabling jumbo frames to increase the mirroring path MTU

Jumbo Frames Switch: 9216 (untagged) On 1-Gbps and 10-Gbps ports in the mirroring path, you can reduce the number of dropped frames by enabling jumbo frames on all intermediate switches and routers. (The MTU on the switches covered by this manual is 9220 bytes for frames having an 802.1Q VLAN tag, and 9216 bytes for… Leer más »

SQL Query for Counting Records per Day

This SQL query will add up the record count per day based on a column called “Timestamp.” Transact SQL SELECT DATEPART(YEAR, Timestamp) AS ‘Year’, DATEPART(MONTH, Timestamp) AS ‘Month’, DATEPART(DAY, Timestamp) AS ‘Day’, COUNT(*) AS ‘Visits’FROM tblVisitsGROUP BY DATEPART(DAY, Timestamp), DATEPART(MONTH, Timestamp), DATEPART(YEAR, Timestamp)ORDER BY ‘Year’, ‘Month’, ‘Day’ Results The results of this query will appear… Leer más »

Pandas Flask

mkdir pandas cd pandas python3 -m venv vpandas Activate the environment Before you work on your project, activate the corresponding environment: . vpandas/bin/activate pip3 install Flask python3 -m flask run –host=0.0.0.0