Thursday 19 November 2020

PYMONGO INSTALLATION STEPS

 PYMONGO INSTALLATION STEPS :

1. Copy & paste pymongo-2.7.1.tar.gz in Home Directory and extract it. 2. Open terminal

>cd pymongo-2.7.1

>sudo python setup.py install

installation complete.

PYMONGO SUPPORT TOOLS INSTALLATION STEPS :

1. Copy & paste pypa-setuptools-9616be97e6a7.tar.gz in Home Directory and extract it.

2. Open terminal

>cd pypa-setuptools-9616be97e6a7

>sudo python setup.py install

installation complete.

Copy & paste jdk-7u25-linux-i586.tar.gz in home folder and extract it.

Copy & paste eclipse-jee-luna-R-linux-gtk.tar.gz in home folder & extract it. Copy & paste apache-tomcat-7.0.55.tar.gz in home folder and extract it. Copy & paste mysql-connector-java-5.1.18-bin.jar in home folder, apache-tomcat-7.0.55/bin, apache-tomcat-7.0.55/lib.

Copy & paste mongo-java-driver-2.12.2.jar in home folder

PYTHON INSTALLATION STEPS

 PYTHON INSTALLATION STEPS :

1. Copy Python-3.3.2.tar.bz2 and Django-1.5.2.tar.gz & paste both in Home Directory and extract them.

2. Open terminal

>cd Django-1.5.2

>sudo python setup.py install

  

 installation complete.

MONGODB INSTALLATION STEPS

 MONGODB INSTALLATION STEPS :

1. Copy & paste mongodb-linux-i686-2.4.6.tgz and extract it in home folder and create one folder in mongodb-linux-i686-2.4.6 \bin folder (ex. snjb) >sudo mkdir /data

>sudo mkdir /data/db

>sudo chmod 777 /data/*

>cd ~/mongodb-linux-i686-2.4.6/bin >./mongod --dbpath snjb

right click and open new terminal and give following command >./mongo

installation complete.

Friday 13 November 2020

Difference between Intel Core i3, i5 and i7

Difference between Intel Core i3, i5 and i7
To conclude in a statement, Core i7s are better than Core i5s, and Core i5s are better than Core i3s. The main reason here being performance. In general, Core i3 chips are found in budget PCs and low-end laptops. For a normal user who does browsing and watching videos, Core i3 works just fine. Core i3s have a low Cache size.
The mainstream or mid-range systems usually  have i5. Systems with Core i5 are good for a moderate user and light gamer.

Wednesday 13 May 2020

Text Editor Python Using tkinter

Text Editor using python




from tkinter import *
from tkinter.filedialog import *
from tkinter.messagebox import *
from tkinter.font import Font
from tkinter.scrolledtext import *
import file_menu
import edit_menu
import format_menu
import help_menu

root = Tk()

root.title("Text Editor-Untiltled")
root.geometry("300x250+300+300")
root.minsize(width=400, height=400)

text = ScrolledText(root, state='normal', height=400, width=400, wrap='word', pady=2, padx=3, undo=True)
text.pack(fill=Y, expand=1)
text.focus_set()

menubar = Menu(root)

file_menu.main(root, text, menubar)
edit_menu.main(root, text, menubar)
format_menu.main(root, text, menubar)
help_menu.main(root, text, menubar)
root.mainloop()





Youtube video download using python


Hi all,

Code for Youtube video downloader using python.

Program:

#youtube
import webbrowser
print("Mac Plus Tech solution")
print("-------------------------------------")
url = input("ENTER YOUTUBE URL:")
download=url[:12]+"ss"+url[12:]
webbrowser.open_new(download)



Tuesday 21 April 2020

How to Compress 1GB files into 10MB

       Managing space on your hard disk is sometimes a tedious task. Many used to compress their files to save the space. But they could only manage to save a bit . By following the instructions of this article you can Compress 1GB files into 10mb archive.
kgb archiverFirst of all you need to download a software called as KGB Archiver. You can download it by clicking here.
After downloading and installing the software Follow the screenshots below to start archiving.
Step1: Start the KGB Archiver Program and click next.

 





Monday 20 April 2020

MS SQL Server Space / Memory Manegment


Execute This


SELECT SUM(unallocated_extent_page_count) AS [free_pages]

,(SUM(unallocated_extent_page_count) * 1.0 / 128) AS [free_space_MB]

,SUM(version_store_reserved_page_count) AS [version_pages_used]

,(SUM(version_store_reserved_page_count) * 1.0 / 128) AS [version_space_MB]

,SUM(internal_object_reserved_page_count) AS [internal_object_pages_used]

,(SUM(internal_object_reserved_page_count) * 1.0 / 128) AS [internal_object_space_MB]

,SUM(user_object_reserved_page_count) AS [user object pages used]

,(SUM(user_object_reserved_page_count) * 1.0 / 128) AS [user_object_space_MB]

FROM sys.dm_db_file_space_usage;

GO

Activate curl Wamp : windows

The steps are as follows :


  1. Close WAMP (if running)
  2. Navigate to WAMP\bin\php\(your version of php)\
  3. Edit php.ini
  4. Search for curl, uncomment extension=php_curl.dll
  5. Navigate to WAMP\bin\Apache\(your version of apache)\bin\
  6. Edit php.ini
  7. Search for curl, uncomment extension=php_curl.dll
  8. Save both
  9. Restart WAMP

open Rar File Ubuntu




First i need to run :

sudo apt-get install unrar 
for install unrar.


If i want to unpack all files within the .rar files in the same directory
unrar e -r /home/work/software/myfile.rar



if You want to unpack the files in full path
unrar x -r /home/work/software/myfile.rar

tracert cmd Command for Trace Root


tracert cmd Command for Trace Root

syntax

>tracert google.com


-------------------------------------------------------

all over Word cable map
Cables Map: https://www.submarinecablemap.com

speed all over word pont
Speed Meter: http://www.nixi.in/en/mrtg-statistics
--------------------------------------------------------------

oky

-Kishor 

Bluetooth + Arduino Connectivity

/*
 *  The program for ON/ Off LED Using Bluetooth
 *  MAC+tech Development
 *  http://macplustechnology.blogspot.in/
 *  Email: macplustech@gmail.com
 *
 */
char data = 0;                //Variable for storing Bluetooth incoming data
void setup()
{
  Serial.begin(9600);      
  pinMode(13, OUTPUT);        //output pin (+5V)  other connect (GND)
}
void loop()
{
  if(Serial.available() > 0)  // resive data
  {
    data = Serial.read();      //Read the incoming data
    Serial.print(data);        //Print ValueSerial monitor
    Serial.print("\n MAC+tech");      
    if(data == '1')            //Checks whether value of data is equal to 1
      digitalWrite(13, HIGH);  //If value is 1 then LED turns ON
    else if(data == '0')       //Checks whether value of data is equal to 0
      digitalWrite(13, LOW);   //If value is 0 then LED turns OFF
  }                          

}              


load to Arduino And Send data though Android App. where make simple android app. to send data though Bluetooth .....

On off Light Using MObile And Arduino

Steps :

1 . go to http://ai2.appinventor.mit.edu  
    and open Account 
2  Download Android App Source Code from My Drive  https://drive.google.com/open?id=1GS3NbGwm0DaKM89chzyWDuAxkW35xR75

Or  Directly Download APK File from here.. 
3 import this code to http://ai2.appinventor.mit.edu
and Build App Download it Using QR Code Directly Your Android Mobile



Step to run :
 1 . Connect  LED, BT HC-05 To Arduino Upload bellow Program on it  (* IMP NODE : During Upload Arduino Remove Bluetooth HC-05 )
 2.  Using in mobile pair with Bt Devices HC-05 (Default password 1234)
 3. Open App select Device from list connect it
 4. on/ off light  




Write CODE on Arduino AND Config Pin...


CODE:
/* 
 *  
 *  Coder - Kishor M Sonawane




Bluetooth connection:-
Arduino Pins           Bluetooth Pins
RX (Pin 0)     ———->      TX
TX (Pin 1)     ———->      RX
5V             ———->      VCC
GND            ———->      GND


 */
char data = 0;                //Variable for storing received data
void setup() 
{
  Serial.begin(9600);         
  pinMode(13, OUTPUT);        //Sets digital pin 13 as output pin
}
void loop()
{
  if(Serial.available() > 0)  /
  {
    data = Serial.read();      //Read the incoming data and store on variable >> data
    Serial.print(data);       
    Serial.print("\n");        
    if(data == '1')            //Checks whether value of data is equal to 1 
      digitalWrite(13, HIGH);  //If value is 1 then LED turns ON
    else if(data == '0')       
      digitalWrite(13, LOW);   //If value is 0 then LED turns OFF
  }                            
 
}                 




How to delete duplicate records from a SQL data table

  introduction How to delete duplicate records from a SQL data table using CTE (common table expression). Specifies a temporary named result...