What are the common databases in python?-Python Tutorial-php.cn

Home

Backend Development

Python Tutorial

What are the common databases in python?

爱喝马黛茶的安东尼

Jun 12, 2019 am 11:11 AM

python database

What are the common databases in python? Databases are roughly divided into two categories. The first category includes relational databases, and the second category is non-relational databases. The following is an introduction to the relevant knowledge of these two types of databases.

Including relational databases: sqlite, mysql, mssql

Non-relational databases: MongoDB, Redis

What are the common databases in python?

1. Connect to Sqlite

import sqlite3
import traceback
try:
    # 如果表不存在,就创建
    with sqlite3.connect(&#39;test.db&#39;) as conn:
        print("Opened database successfully")
        # 删除表
        conn.execute("DROP TABLE IF EXISTS  COMPANY")
        # 创建表
        sql = """
                 CREATE TABLE IF NOT EXISTS COMPANY
               (ID INTEGER  PRIMARY KEY       AUTOINCREMENT,
               NAME           TEXT    NOT NULL,
               AGE            INT     NOT NULL,
               ADDRESS        CHAR(50),
               SALARY         REAL);
        """
        conn.execute(sql)
        print("create table successfully")
        # 添加数据
        conn.executemany("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY) VALUES (?, ?, ?, ? )",
                         [(&#39;Paul&#39;, 32, &#39;California&#39;, 20000.00),
                          (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00),
                          (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00),
                          (&#39;Mark&#39;, 25, &#39;Rich-Mond &#39;, 65000.00),
                          (&#39;David&#39;, 27, &#39;Texas&#39;, 85000.00),
                          (&#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00),
                          (&#39;James&#39;, 24, &#39;Houston&#39;, 10000.00)])
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES ( &#39;Paul&#39;, 32, &#39;California&#39;, 20000.00 )")
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00 )")
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00 )")
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES ( &#39;Mark&#39;, 25, &#39;Rich-Mond &#39;, 65000.00 )")
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES ( &#39;David&#39;, 27, &#39;Texas&#39;, 85000.00 )");
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES ( &#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00 )")
        #
        # conn.execute("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY)\
        # VALUES ( &#39;James&#39;, 24, &#39;Houston&#39;, 10000.00 )")
        # 提交,否则重新运行程序时,表中无数据
        conn.commit()
        print("insert successfully")
        # 查询表
        sql = """
            select id,NAME,AGE,ADDRESS,SALARY FROM COMPANY
         """
        result = conn.execute(sql)
        for row in result:
            print("-" * 50)  # 输出50个-,作为分界线
            print("%-10s %s" % ("id", row[0]))  # 字段名固定10位宽度,并且左对齐
            print("%-10s %s" % ("name", row[1]))
            print("%-10s %s" % ("age", row[2]))
            print("%-10s %s" % ("address", row[3]))
            print("%-10s %.2f" % ("salary", row[4]))
            # or
            # print(&#39;{:10s} {:.2f}&#39;.format("salary", row[4]))
except sqlite3.Error as e:
    print("sqlite3 Error:", e)
    traceback.print_exc()

Copy after login

2. Connect mysql

Related recommendations: "python video tutorial"

2.2 Using MySQLdb

2.1 Using _mysql in the mysqldb library

import MySQLdb
from contextlib import closing
import traceback
try:
    # 获取一个数据库连接
    with closing(MySQLdb.connect(host=&#39;localhost&#39;, user=&#39;root&#39;, passwd=&#39;root&#39;, db=&#39;test&#39;, port=3306,charset=&#39;utf8&#39;)) as conn:
        print("connect database successfully")
        with closing(conn.cursor()) as cur:
            # 删除表
            cur.execute("DROP TABLE IF EXISTS  COMPANY")
            # 创建表
            sql = """
                     CREATE TABLE IF NOT EXISTS COMPANY
                   (ID INTEGER  PRIMARY KEY NOT NULL  auto_increment,
                   NAME           TEXT    NOT NULL,
                   AGE            INT     NOT NULL,
                   ADDRESS        CHAR(50),
                   SALARY         REAL);
            """
            cur.execute(sql)
            print("create table successfully")
            # 添加数据
            # 在一个conn.execute里面里面执行多个sql语句是非法的
            cur.executemany("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY) VALUES ( %s, %s, %s, %s )",
                            [(&#39;Paul&#39;, 32, &#39;California&#39;, 20000.00),
                             (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00),
                             (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00),
                             (&#39;Mark&#39;, 25, &#39;Rich-Mond &#39;, 65000.00),
                             (&#39;David&#39;, 27, &#39;Texas&#39;, 85000.00),
                             (&#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00),
                             (&#39;James&#39;, 24, &#39;Houston&#39;, 10000.00)])
            # 提交,否则重新运行程序时,表中无数据
            conn.commit()
            print("insert successfully")
            # 查询表
            sql = """
                select id,NAME,AGE,ADDRESS,SALARY FROM COMPANY
             """
            cur.execute(sql)
            for row in cur.fetchall():
                print("-" * 50)  # 输出50个-,作为分界线
                print("%-10s %s" % ("id", row[0]))  # 字段名固定10位宽度,并且左对齐
                print("%-10s %s" % ("name", row[1]))
                print("%-10s %s" % ("age", row[2]))
                print("%-10s %s" % ("address", row[3]))
                print("%-10s %s" % ("salary", row[4]))
except MySQLdb.Error as e:
    print("Mysql Error:", e)
    traceback.print_exc()  # 打印错误栈信息

Copy after login

2.2 Using MySQLdb

import MySQLdb
from contextlib import closing
import traceback
try:
    # 获取一个数据库连接
    with closing(MySQLdb.connect(host=&#39;localhost&#39;, user=&#39;root&#39;, passwd=&#39;root&#39;, db=&#39;test&#39;, port=3306,charset=&#39;utf8&#39;)) as conn:
        print("connect database successfully")
        with closing(conn.cursor()) as cur:
            # 删除表
            cur.execute("DROP TABLE IF EXISTS  COMPANY")
            # 创建表
            sql = """
                     CREATE TABLE IF NOT EXISTS COMPANY
                   (ID INTEGER  PRIMARY KEY NOT NULL  auto_increment,
                   NAME           TEXT    NOT NULL,
                   AGE            INT     NOT NULL,
                   ADDRESS        CHAR(50),
                   SALARY         REAL);
            """
            cur.execute(sql)
            print("create table successfully")
            # 添加数据
            # 在一个conn.execute里面里面执行多个sql语句是非法的
            cur.executemany("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY) VALUES ( %s, %s, %s, %s )",
                            [(&#39;Paul&#39;, 32, &#39;California&#39;, 20000.00),
                             (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00),
                             (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00),
                             (&#39;Mark&#39;, 25, &#39;Rich-Mond &#39;, 65000.00),
                             (&#39;David&#39;, 27, &#39;Texas&#39;, 85000.00),
                             (&#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00),
                             (&#39;James&#39;, 24, &#39;Houston&#39;, 10000.00)])
            # 提交,否则重新运行程序时,表中无数据
            conn.commit()
            print("insert successfully")
            # 查询表
            sql = """
                select id,NAME,AGE,ADDRESS,SALARY FROM COMPANY
             """
            cur.execute(sql)
            for row in cur.fetchall():
                print("-" * 50)  # 输出50个-,作为分界线
                print("%-10s %s" % ("id", row[0]))  # 字段名固定10位宽度,并且左对齐
                print("%-10s %s" % ("name", row[1]))
                print("%-10s %s" % ("age", row[2]))
                print("%-10s %s" % ("address", row[3]))
                print("%-10s %s" % ("salary", row[4]))
except MySQLdb.Error as e:
    print("Mysql Error:", e)
    traceback.print_exc()  # 打印错误栈信息

Copy after login

2.3 Use pymysql

Section 2.1 and 2.2 use MySQLdb, which does not support Python3.x
pymysql has better support for Python2.x and Python3.x

import pymysql
from contextlib import closing
import traceback
try:
    # 获取一个数据库连接,with关键字 表示退出时,conn自动关闭
    # with 嵌套上一层的with 要使用closing()
    with closing(pymysql.connect(host=&#39;localhost&#39;, user=&#39;root&#39;, passwd=&#39;root&#39;, db=&#39;test&#39;, port=3306,
                                 charset=&#39;utf8&#39;)) as conn:
        print("connect database successfully")
        # 获取游标,with关键字 表示退出时,cur自动关闭
        with conn.cursor() as cur:
            # 删除表
            cur.execute("DROP TABLE IF EXISTS  COMPANY")
            # 创建表
            sql = """
                     CREATE TABLE IF NOT EXISTS COMPANY
                   (ID INTEGER  PRIMARY KEY NOT NULL  auto_increment,
                   NAME           TEXT    NOT NULL,
                   AGE            INT     NOT NULL,
                   ADDRESS        CHAR(50),
                   SALARY         REAL);
            """
            cur.execute(sql)
            print("create table successfully")
            # 添加数据
            # 在一个conn.execute里面里面执行多个sql语句是非法的
            cur.executemany("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY) VALUES ( %s, %s, %s, %s )",
                            [(&#39;Paul&#39;, 32, &#39;California&#39;, 20000.00),
                             (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00),
                             (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00),
                             (&#39;Mark&#39;, 25, &#39;Rich-Mond &#39;, 65000.00),
                             (&#39;David&#39;, 27, &#39;Texas&#39;, 85000.00),
                             (&#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00),
                             (&#39;James&#39;, 24, &#39;Houston&#39;, 10000.00)])
            # 提交,否则重新运行程序时,表中无数据
            conn.commit()
            print("insert successfully")
            # 查询表
            sql = """
                select id,NAME,AGE,ADDRESS,SALARY FROM COMPANY
             """
            cur.execute(sql)
            for row in cur.fetchall():
                print("-" * 50)  # 输出50个-,作为分界线
                print("%-10s %s" % ("id", row[0]))  # 字段名固定10位宽度,并且左对齐
                print("%-10s %s" % ("name", row[1]))
                print("%-10s %s" % ("age", row[2]))
                print("%-10s %s" % ("address", row[3]))
                print("%-10s %s" % ("salary", row[4]))
except pymysql.Error as e:
    print("Mysql Error:", e)
    traceback.print_exc()

Copy after login

3.Connect to mssql

import pymssql
from contextlib import closing
try:
    # 先要保证数据库中有test数据库
    # 获取一个数据库连接,with关键字 表示退出时,conn自动关闭
    # with 嵌套上一层的with 要使用closing()
    with closing(pymssql.connect(host=&#39;192.168.100.114&#39;, user=&#39;sa&#39;, password=&#39;sa12345&#39;, database=&#39;test&#39;, port=1433,
                                 charset=&#39;utf8&#39;)) as conn:
        print("connect database successfully")
        # 获取游标,with关键字 表示退出时,cur自动关闭
        with conn.cursor() as cur:
            # 删除表
            cur.execute(
                    &#39;&#39;&#39;if exists (select 1 from  sys.objects where name=&#39;COMPANY&#39; and  type=&#39;U&#39;)  drop table COMPANY&#39;&#39;&#39;)
            # 创建表
            sql = """
                     CREATE TABLE  COMPANY
                   (ID INT  IDENTITY(1,1) PRIMARY KEY NOT NULL ,
                   NAME           TEXT    NOT NULL,
                   AGE            INT     NOT NULL,
                   ADDRESS        CHAR(50),
                   SALARY         REAL);
            """
            cur.execute(sql)
            print("create table successfully")
            # 添加数据
            # 在一个conn.execute里面里面执行多个sql语句是非法的
            cur.executemany("INSERT INTO COMPANY (NAME,AGE,ADDRESS,SALARY) VALUES ( %s, %s, %s, %s )",
                            [(&#39;Paul&#39;, 32, &#39;California&#39;, 20000.00),
                             (&#39;Allen&#39;, 25, &#39;Texas&#39;, 15000.00),
                             (&#39;Teddy&#39;, 23, &#39;Norway&#39;, 20000.00),
                             (&#39;Mark&#39;, 25, &#39;Rich-Mond&#39;, 65000.00),
                             (&#39;David&#39;, 27, &#39;Texas&#39;, 85000.00),
                             (&#39;Kim&#39;, 22, &#39;South-Hall&#39;, 45000.00),
                             (&#39;James&#39;, 24, &#39;Houston&#39;, 10000.00)])
            # 提交,否则重新运行程序时,表中无数据
            conn.commit()
            print("insert successfully")
            # 查询表
            sql = """
                select id,NAME,AGE,ADDRESS,SALARY FROM COMPANY
             """
            cur.execute(sql)
            for row in cur.fetchall():
                print("-" * 50)  # 输出50个-,作为分界线
                print("%-10s %s" % ("id", row[0]))  # 字段名固定10位宽度,并且左对齐
                print("%-10s %s" % ("name", row[1]))
                print("%-10s %s" % ("age", row[2]))
                print("%-10s %s" % ("address", row[3]))
                print("%-10s %s" % ("salary", row[4]))
except pymssql.Error as e:
    print("mssql Error:", e)
    # traceback.print_exc()

Copy after login

4.Connect to MongoDB

import pymongo
from pymongo.mongo_client import MongoClient
import pymongo.errors
import traceback
try:
    # 连接到 mongodb 服务
    mongoClient = MongoClient(&#39;localhost&#39;, 27017)
    # 连接到数据库
    mongoDatabase = mongoClient.test
    print("connect database successfully")
    # 获取集合
    mongoCollection = mongoDatabase.COMPANY
    # 移除所有数据
    mongoCollection.remove()
    # 添加数据
    mongoCollection.insert_many([{"Name": "Paul", "Age": "32", "Address": "California", "Salary": "20000.00"},
                                 {"Name": "Allen", "Age": "25", "Address": "Texas", "Salary": "15000.00"},
                                 {"Name": "Teddy", "Age": "23", "Address": "Norway", "Salary": "20000.00"},
                                 {"Name": "Mark", "Age": "25", "Address": "Rich-Mond", "Salary": "65000.00"},
                                 {"Name": "David", "Age": "27", "Address": "Texas", "Salary": "85000.00"},
                                 {"Name": "Kim", "Age": "22", "Address": "South-Hall", "Salary": "45000.00"},
                                 {"Name": "James", "Age": "24", "Address": "Houston", "Salary": "10000.00"}, ])
    #获取集合中的值
    for row in mongoCollection.find():
        print("-" * 50)  # 输出50个-,作为分界线
        print("%-10s %s" % ("_id", row[&#39;_id&#39;]))  # 字段名固定10位宽度,并且左对齐
        print("%-10s %s" % ("name", row[&#39;Name&#39;]))
        print("%-10s %s" % ("age", row[&#39;Age&#39;]))
        print("%-10s %s" % ("address", row[&#39;Address&#39;]))
        print("%-10s %s" % ("salary", row[&#39;Salary&#39;]))
    print(&#39;\n\n\n&#39;)
    # 使id自增
    mongoCollection.remove()
    # 创建计数表
    mongoDatabase.counters.save({"_id": "people_id", "sequence_value": 0})
    # 创建存储过程
    mongoDatabase.system_js.getSequenceValue = &#39;&#39;&#39;function getSequenceValue(sequenceName){
            var sequenceDocument = db.counters.findAndModify({
                query: {_id: sequenceName},
                update: {$inc:{sequence_value: 1}},
                new:true
            });
            return sequenceDocument.sequence_value;
        }&#39;&#39;&#39;
    mongoCollection.insert_many(
            [{"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "Paul", "Age": "32",
              "Address": "California", "Salary": "20000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "Allen", "Age": "25",
              "Address": "Texas", "Salary": "15000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "Teddy", "Age": "23",
              "Address": "Norway", "Salary": "20000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "Mark", "Age": "25",
              "Address": "Rich-Mond", "Salary": "65000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "David", "Age": "27",
              "Address": "Texas", "Salary": "85000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "Kim", "Age": "22",
              "Address": "South-Hall", "Salary": "45000.00"},
             {"_id": mongoDatabase.eval("getSequenceValue(&#39;people_id&#39;)"), "Name": "James", "Age": "24",
              "Address": "Houston", "Salary": "10000.00"}, ])
    for row in mongoCollection.find():
        print("-" * 50)  # 输出50个-,作为分界线
        print("%-10s %s" % ("_id", int(row[&#39;_id&#39;])))  # 字段名固定10位宽度,并且左对齐
        print("%-10s %s" % ("name", row[&#39;Name&#39;]))
        print("%-10s %s" % ("age", row[&#39;Age&#39;]))
        print("%-10s %s" % ("address", row[&#39;Address&#39;]))
        print("%-10s %s" % ("salary", row[&#39;Salary&#39;]))
except pymongo.errors.PyMongoError as e:
    print("mongo Error:", e)
    traceback.print_exc()

Copy after login

5.Connect to Redis

5.1Using redis

import redis
r = redis.Redis(host=&#39;localhost&#39;, port=6379, db=0, password="12345")
print("connect", r.ping())
# 看信息
info = r.info()
# or 查看部分信息
# info = r.info("Server")
# 输出信息
items = info.items()
for i, (key, value) in enumerate(items):
    print("item %s----%s:%s" % (i, key, value))
# 删除键和对应的值
r.delete("company")
# 可以一次性push一条或多条数据
r.rpush("company", {"id": 1, "Name": "Paul", "Age": "32", "Address": "California", "Salary": "20000.00"},
        {"id": 2, "Name": "Allen", "Age": "25", "Address": "Texas", "Salary": "15000.00"},
        {"id": 3, "Name": "Teddy", "Age": "23", "Address": "Norway", "Salary": "20000.00"})
r.rpush("company", {"id": 4, "Name": "Mark", "Age": "25", "Address": "Rich-Mond", "Salary": "65000.00"})
r.rpush("company", {"id": 5, "Name": "David", "Age": "27", "Address": "Texas", "Salary": "85000.00"})
r.rpush("company", {"id": 6, "Name": "Kim", "Age": "22", "Address": "South-Hall", "Salary": "45000.00"})
r.rpush("company", {"id": 7, "Name": "James", "Age": "24", "Address": "Houston", "Salary": "10000.00"})
# eval用来将dict格式的字符串转换成dict
for row in map(lambda x: eval(x), r.lrange("company", 0, r.llen("company"))):
    print("-" * 50)  # 输出50个-,作为分界线
    print("%-10s %s" % ("_id", row[&#39;id&#39;]))  # 字段名固定10位宽度,并且左对齐
    print("%-10s %s" % ("name", row[&#39;Name&#39;]))
    print("%-10s %s" % ("age", row[&#39;Age&#39;]))
    print("%-10s %s" % ("address", row[&#39;Address&#39;]))
    print("%-10s %s" % ("salary", row[&#39;Salary&#39;]))
# 关闭当前连接
# r.shutdown() #这个是关闭redis服务端

Copy after login

5.2Using pyredis

import pyredis
r = pyredis.Client(host=&#39;localhost&#39;, port=6379, database=0, password="12345")
print("connect", r.ping().decode("utf-8"))
# 看信息
# info = r.execute("info").decode()
# or 查看部分信息
info = r.execute("info", "Server").decode()
# 输出信息
print(info)
# 删除键和对应的值
r.delete("company")
# 可以一次性push一条或多条数据
r.rpush("company", &#39;&#39;&#39;{"id": 1, "Name": "Paul", "Age": "32", "Address": "California", "Salary": "20000.00"}&#39;&#39;&#39;,
        &#39;&#39;&#39;{"id": 2, "Name": "Allen", "Age": "25", "Address": "Texas", "Salary": "15000.00"}&#39;&#39;&#39;,
        &#39;&#39;&#39;{"id": 3, "Name": "Teddy", "Age": "23", "Address": "Norway", "Salary": "20000.00"}&#39;&#39;&#39;)
r.rpush("company", &#39;&#39;&#39;{"id": 4, "Name": "Mark", "Age": "25", "Address": "Rich-Mond", "Salary": "65000.00"}&#39;&#39;&#39;)
r.rpush("company", &#39;&#39;&#39;{"id": 5, "Name": "David", "Age": "27", "Address": "Texas", "Salary": "85000.00"}&#39;&#39;&#39;)
r.rpush("company", &#39;&#39;&#39;{"id": 6, "Name": "Kim", "Age": "22", "Address": "South-Hall", "Salary": "45000.00"}&#39;&#39;&#39;)
r.rpush("company", &#39;&#39;&#39;{"id": 7, "Name": "James", "Age": "24", "Address": "Houston", "Salary": "10000.00"}&#39;&#39;&#39;)
# eval用来将dict格式的字符串转换成dict
for row in map(lambda x: eval(x), r.lrange("company", 0, r.llen("company"))):
    print("-" * 50)  # 输出50个-,作为分界线
    print("%-10s %s" % ("_id", row[&#39;id&#39;]))  # 字段名固定10位宽度,并且左对齐
    print("%-10s %s" % ("name", row[&#39;Name&#39;]))
    print("%-10s %s" % ("age", row[&#39;Age&#39;]))
    print("%-10s %s" % ("address", row[&#39;Address&#39;]))
    print("%-10s %s" % ("salary", row[&#39;Salary&#39;]))
# 关闭当前连接
r.close()

Copy after login

The above is the detailed content of What are the common databases in python?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

What's New in Windows 11 KB5054979 & How to Fix Update Issues

3 weeks ago By DDD

How to fix KB5055523 fails to install in Windows 11?

2 weeks ago By DDD

InZoi: How To Apply To School And University

4 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

2 weeks ago By DDD

Where to find the Site Office Key in Atomfall

4 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Where is the login entrance for gmail email?

7870

Java Tutorial

1649

CakePHP Tutorial

1407

Laravel Tutorial

1301

PHP Tutorial

1244

Related knowledge

PHP and Python: Different Paradigms Explained Apr 18, 2025 am 12:26 AM

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

Choosing Between PHP and Python: A Guide Apr 18, 2025 am 12:24 AM

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP and Python: A Deep Dive into Their History Apr 18, 2025 am 12:25 AM

PHP originated in 1994 and was developed by RasmusLerdorf. It was originally used to track website visitors and gradually evolved into a server-side scripting language and was widely used in web development. Python was developed by Guidovan Rossum in the late 1980s and was first released in 1991. It emphasizes code readability and simplicity, and is suitable for scientific computing, data analysis and other fields.

Python vs. JavaScript: The Learning Curve and Ease of Use Apr 16, 2025 am 12:12 AM

Python is more suitable for beginners, with a smooth learning curve and concise syntax; JavaScript is suitable for front-end development, with a steep learning curve and flexible syntax. 1. Python syntax is intuitive and suitable for data science and back-end development. 2. JavaScript is flexible and widely used in front-end and server-side programming.

How to run sublime code python Apr 16, 2025 am 08:48 AM

To run Python code in Sublime Text, you need to install the Python plug-in first, then create a .py file and write the code, and finally press Ctrl B to run the code, and the output will be displayed in the console.

Oracle's Role in the Business World Apr 23, 2025 am 12:01 AM

Oracle is not only a database company, but also a leader in cloud computing and ERP systems. 1. Oracle provides comprehensive solutions from database to cloud services and ERP systems. 2. OracleCloud challenges AWS and Azure, providing IaaS, PaaS and SaaS services. 3. Oracle's ERP systems such as E-BusinessSuite and FusionApplications help enterprises optimize operations.

Where to write code in vscode Apr 15, 2025 pm 09:54 PM

Writing code in Visual Studio Code (VSCode) is simple and easy to use. Just install VSCode, create a project, select a language, create a file, write code, save and run it. The advantages of VSCode include cross-platform, free and open source, powerful features, rich extensions, and lightweight and fast.

How to run python with notepad Apr 16, 2025 pm 07:33 PM

Running Python code in Notepad requires the Python executable and NppExec plug-in to be installed. After installing Python and adding PATH to it, configure the command "python" and the parameter "{CURRENT_DIRECTORY}{FILE_NAME}" in the NppExec plug-in to run Python code in Notepad through the shortcut key "F6".

See all articles