Updating records of search strings
The Windows binary distribution works out of the box with SQLite, MSSQL, Postgresql and My SQL.The Mac binary distribution works out of the box with SQLite. The IMAP option allows to use DAL to access IMAP.web2py defines the following classes that make up the DAL: The DAL object represents a database connection.As explained above, I only want to display the first N items that match the query.Therefore, for N small enough, it should not be a big issue loading the matching items from the database.web2py comes with a Database Abstraction Layer (DAL), an API that maps Python objects into database objects such as queries, tables, and records.The DAL dynamically generates the SQL in real time using the specified dialect for the database back end, so that you do not have to write SQL code or learn different SQL dialects (the term SQL is used generically), and the application will be portable among different types of databases.A partial list of supported databases is show in the table below.Please check on the web2py web site and mailing list for more recent adapters.
The DAL allows multiple connections with the same database or with different databases, even databases of different types.
I have the following problem: I have a database containing more than 2 million records.
Each record has a string field X and I want to display a list of records for which field X contains a certain string. To make it more concrete: in the GUI of my application I have a text field where I can enter a string.
Above the text field I have a table displaying the (first N, e.g.
100) records that match the string in the text field.
Search for updating records of search strings:
java JDBCExample Connecting to a selected database...