免费的数据库DBaaS之 Astra — 云 Cassandra 80GB free tier

很多群友都有自己的vps主机，一个vps上装上数据库，可能会导致可用资源太小。我当然建议你买高性能主机，但有的群友还是学生，暂时不具备付费能力。

有动手能力的朋友，自然推荐你申请免费的云数据库存储，即 DBaaS。

废话不说，申请网址：

Astra — 免费申请 free tier

注册，验证邮箱

填写调查问卷

可以创建数据库了。

免费套餐，只可以在gcp创建数据库了。

如果用的是python，可以按照文档，对数据库进行愉快的访问了。

from cassandra.cluster import Cluster
from cassandra.auth import PlainTextAuthProvider

def set_user(session, lastname, age, city, email, firstname):
     # TO DO: execute SimpleStatement that inserts one user into the table
    session.execute("INSERT INTO users (lastname, age, city, email, firstname) VALUES (%s,%s,%s,%s,%s)", [lastname, age, city, email, firstname])

def get_user(session, lastname):
    # TO DO: execute SimpleStatement that retrieves one user from the table
    # TO DO: print firstname and age of user
    result = session.execute("SELECT * FROM users WHERE lastname = %(surname)s", {'surname':lastname}).one()
    print result.firstname, result.age

def update_user(session, new_age, lastname):
    # TO DO: execute a BoundStatement that updates the age of one user
    prepared = session.prepare("UPDATE users SET age = ? WHERE lastname = ?")
    session.execute(prepared, [new_age, lastname])

def delete_user(session, lastname):
    # TO DO: execute a BoundStatement that updates the age of one user
    prepared = session.prepare("DELETE FROM users WHERE lastname = ?")
    session.execute(prepared, [lastname])

def main():

    cloud_config= {
        'secure_connect_bundle': '/path/to/secure-connect-database_name.zip'
    }
    auth_provider = PlainTextAuthProvider('clientId', 'clientSecret')
    cluster = Cluster(cloud=cloud_config, auth_provider=auth_provider)
    session = cluster.connect('demo')

    session.execute(
        """
        CREATE TABLE IF NOT EXISTS demo.users (
            lastname text PRIMARY KEY,
            age int,
            city text,
            email text,
            firstname text);
        """
        )

    lastname = "Jones"
    age = 35
    city = "Austin"
    email = "bob@example.com"
    firstname = "Bob"
    new_age = 36

    set_user(session, lastname, age, city, email, firstname)

    get_user(session, lastname)

    update_user(session, new_age, lastname)

    get_user(session, lastname)

    delete_user(session, lastname)

if __name__ == "__main__":
    main()

简单总结：

此数据库的优点： 1 空间高达80G 2 注册简单不需要绑卡。

和之前分享的tidbcloud相比，没有提供亚洲优化的区域，网络速度一般。

其他免费云数据库（更新请看 https://zhuji188.com/724.html ）：

更多免费数据库vps等，访问https://zhuji188.com/758.html