Each program that needs to connect to the database must first open it on the server. There are many ways to do this!
Using System Data Source (DSN)
This must be set on the server. This is the best and fastest way to access data. Because it only needs to authenticate on the server on the line, do not need to join.
Working with file data sources
This is not a rec
Click on the link text above to quickly follow the "East Cloud Insights" public numberAfter nine months of testing, Amazon Web Services now offers the Aurora Aurora database service as a complete business service, which is positioned as a high performance alternative to the widely used open source MySQL product."For most workloads we recommend using the Amazon Au
. Therefore, C/C ++ is the most straightforward to use. If you do not like the process-oriented c api style, you can find another c ++ packaging library. If you want to re-invent the wheel, you can package one by yourself.◇ JavaIf you want to use Java to access SQLite, you can use the JDBC driver of SQLite or a specialized SQLite packaging library. I personally suggest using the JDBC Method. If you want to change the database in the future, you don't
table of Hubble.net
Data Type of Hubble.net data table
Create and delete Databases
Create a data table
Create full-text indexes for existing tables or views of the database (1) Append Only mode
Create full-text index for existing tables or views of the database (2) Updatable Mode
Create full-text index for existing tables or views of the database (3) Multi-table
Search process *
HubbleDotNet open-source full-text search database project -- Query Method Summary
Search for the Tokenized field *
Search syntax *
Specify word weight
Field weight
Specify document weight
Match Method
Contains Method
Like mode *
Combined search *
Search by combining the Tokenized field and the Untokenized field *
Search by combining the Tokeniz
combination conditions queryNoSQL methodRedundancy methodNote: Think about the scope of the method of splitting, how to solve.Non-partition key cross-Library cross-table paging query problem (horizontal sub-Library sub-table, split strategy for common hash method)Note: Use the NoSQL method to solve (es, etc.).Scaling problem (horizontal sub-Library sub-table, split strategy is a common hash method)Horizontal expansion library (upgrade from library method)Note: The expansion is multiplied.Horizo
of a variety of common architectures, the rest is how to choose the right architecture to use in a real-world production environment. In this respect everyone has their own ideas and experience, the specific plan is the best of opinion. In the daily work of the structure of the perfect is not an overnight, but a constantly evolving process of optimization and improvement. A push in the database also experienced from a single point to master-slave to
problems.
Database scalability
Speaking of database scalability, this is a big topic. Currently, commercial data has its own scalability solutions, which are relatively mature in the past. However, with the rapid development of the Internet, it will inevitably lead to the evolution of some computing models, in this way, many mainstream business systems will inevitably expose some shortcomings. For example,
problem of database extensibility.
A matter of database extensibility
Speaking of database extensibility, this is a very big topic. The current business data has its own expansion solution, in the past relatively mature, but with the rapid development of the Internet, inevitably will bring some calculation mode of evolution, so many mainstream business systems
This is a creation in
Article, where the information may have evolved or changed.
Brief introduction
Project Open Source Address: Https://github.com/HouzuoGuo/tiedot
The initiator left his Twitter, apparently surnamed Guo, a Chinese-American.
In the project introduction, there is a description of the performance, someone used this database to crawl Wikipedia,
On the blog of the source of inspiration in open source, I saw this article: Open Source pure C # lightweight Database Engine: SharpHSQL 1.0.3.0.
I have used many similar database engin
HubbleDotNet is an open-source, free full-text search Database Component Based on. net framework.
HubbleDotNet IntroductionHubbleDotNet and mongoe.net Performance Comparison Test
Installation and upgrade
Install
Upgrade
User permission-in function planning
Default Account
Add account
Account Permissions
Index
Database
directly to vitess.Process Management Vitess helps you manage the life cycle of your DB instances through automated processing of various scenarios, such as failover, master-slave replication. Vitess also tracks metadata in all cluster configurations so that different cluster views are always up-to-date and consistently consistent for different clients. In addition, your own application does not need to track changes in the database topology.Original
Label:
DBCP Database Connection Pool
C3P0 Database Connection Pool
DBCP is an open source connection pool implementation under the Apache Software fund, and to use the DBCP data source, the application should add the following two jar files to the system:
Objective
The industry's quest for persistent storage has never stopped, and many new technologies have sprung up in the open source and in the business world to make it easier and easier to express our minds with objects. In the past year, the industry has also been reflecting on whether ORM brings us convenience or trouble. Pointing to the famous Hibernate, have talked about its performance problems, we
Dblayer, my recent open source database lightweight ORM Framework, currently supports SQL Server, MySQL, and Oracle, especially in the paging package.The framework has been upgraded from 78 ago and has undergone a number of projects, hoping to liberate everyone from the SQL string.Open Source AddressHttps://github.com/
Sofire suite is a suite developed by individuals starting in August 2009. After several years of continuous optimization and improvement, from the initial v suite to sofire2011 to the current sofire. V1.0, sofire has experienced many project tests and accomplished its mission well. Now, I refactor this set of components,
Try to make it the underlying preferred choice for any platform, framework, and suite . With the spirit of open
Open source database connection pool
Generally, the implementation of datasource is called a data source in English. The data source includes the implementation of the database connection pool.
1. DBCP
The following content collection systems are all in English and do not need to use databases. They are free and open-source CMS in foreign countries. How about Chinese support? Try it on your own!
The following content collection systems are all in English and do not need to use databases. They are free and open-source
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.