Please beware that as of 18th November the W3C is no longer actively working on the Web SQL Database specification. The Web SQL database API isnt actually part of. The following tables compare general and technical information for a number of relational database management systems. Please see the individual products articles. Hi, I have long experience with Informix where cursors are used almost anywhere. Recently Ive started with MS SQL and I was surprised found warnings from many. Java Inmemory database delivering the power of objects integrated with a relational database and SQL92. FirstSQLJ Java DB provides realtime performance, SQL and. Sphinx Open Source Search Server. Data source configuration options. Data source type. Mandatory, no default value. Known types are mysql, pgsql, mssql. All other per source options depend on source type selected by this option. Heterogeneous Database connections Oracle to SQL Server Oracle Database Tips by Donald Burleson. I have been trying to run debugging within SQl server management studio and for some reason the debugger has just stopped working. This is the message I get Unable. Has high indexing speed upto 1015 MBsec per core on an internal benchmark has high search speed upto 150250 queriessec per core against 1,000,000 documents, 1. Names of the options used for SQL sources ie. My. SQL, Postgre. SQL, MS SQL start with sql. All source types are conditional they might or might. Windows. odbc type is available both on Windows natively and on. Linux through Unix. ODBC library. SQL server host to connect to. Mandatory, no default value. Applies to SQL source types mysql, pgsql, mssql only. In the simplest case when Sphinx resides on the same host with your My. SQL. or Postgre. SQL installation, you would simply specify localhost. Note that. My. SQL client library chooses whether to connect over TCPIP or over UNIX. Specifically localhost will force it. UNIX socket this is the default and generally recommended mode. TCPIP usage. Refer to. SQL server IP port to connect to. Optional, default is 3. Applies to SQL source types mysql, pgsql, mssql only. Note that it depends on sqlhost setting whether this value will actually be used. SQL user to use when connecting to sqlhost. Mandatory, no default value. Applies to SQL source types mysql, pgsql, mssql only. SQL user password to use when connecting to sqlhost. Mandatory, no default value. Applies to SQL source types mysql, pgsql, mssql only. SQL database in My. SQL terms to use after the connection and perform further queries within. Mandatory, no default value. Applies to SQL source types mysql, pgsql, mssql only. UNIX socket name to connect to for local SQL servers. Optional, default value is empty use client library default settings. Applies to SQL source types mysql, pgsql, mssql only. On Linux, it would typically be varlibmysqlmysql. On Free. BSD, it would typically be tmpmysql. Note that it depends on sqlhost setting whether this value will actually be used. My. SQL client connection flags. Optional, default value is 0 do not set any flags. Applies to mysql source type only. This option must contain an integer value with the sum of the flags. The value will be passed to mysqlrealconnect verbatim. The flags are enumerated in mysqlcom. Flags that are especially interesting in regard to indexing, with their respective values, are as follows. CLIENTCOMPRESS 3. CLIENTSSL 2. 04. SSL after handshake. CLIENTSECURECONNECTION 3. For instance, you can specify 2. SSL. or 3. 27. 68 to use new authentication only. Initially, this option was introduced. Compression on 1 Gbps. However, enabling compression on 1. Mbps links. may improve indexing time significantly upto 2. Your mileage may vary. SSL certificate settings to use for connecting to My. SQL server. Optional, default values are empty strings do not use SSL. Applies to mysql source type only. These directives let you set up secure SSL connection between. My. SQL. The details on creating. My. SQL server can be found in. My. SQL documentation. ODBC DSN to connect to. Mandatory, no default value. Applies to odbc source type only. ODBC DSN Data Source Name specifies the credentials host, user, password, etc. ODBC data source. The format depends on specific ODBC. DriverOracle ODBC Driver Dbqmy. DBName Uidmy. Username Pwdmy. Password. Pre fetch query, or pre query. Multi value, optional, default is empty list of queries. Applies to SQL source types mysql, pgsql, mssql only. Multi value means that you can specify several pre queries. They are executed before the main fetch query. Pre query results are ignored. Pre queries are useful in a lot of ways. They are used to setup encoding. SQL server options and variables, and so on. Perhaps the most frequent pre query usage is to specify the encoding. Note that Sphinx accepts. UTF 8 texts. Two My. SQL specific examples of setting the encoding are. SET CHARACTERSETRESULTSutf. SET NAMES utf. 8. Also specific to My. SQL sources, it is useful to disable query cache. That could be achieved with. SET SESSION querycachetypeOFF. SET NAMES utf. 8. SET SESSION querycachetypeOFF. Main document fetch query. Mandatory, no default value. Applies to SQL source types mysql, pgsql, mssql only. There can be only one main query. This is the query which is used to retrieve documents from SQL server. You can specify up to 3. SPHMAXFIELDS from sphinx. All of the columns that are neither document ID the first one nor attributes will be full text indexed. Document ID MUST be the very first field. MUST BE UNIQUE UNSIGNED POSITIVE NON ZERO, NON NEGATIVE INTEGER NUMBER. It can be either 3. Sphinx. by default it builds with 3. IDs support but enable id. IDs support. SELECT id, groupid, UNIXTIMESTAMPdateadded AS dateadded,. FROM documents. 1. Joinedpayload field fetch query. Multi value, optional, default is empty list of queries. Applies to SQL source types mysql, pgsql, mssql only. Its syntax is as follows. FIELD NAME from query payload query. QUERY RANGE QUERY. FIELD NAME is a joinedpayload field name QUERY is an SQL query that must fetch values to index. RANGE QUERY is an optional SQL query that fetches a range. Added in version 2. Joined fields let you avoid JOIN andor GROUPCONCAT statements in the main. This can be useful when SQL side JOIN is slow. Sphinx side, or simply to emulate My. SQL specific. GROUPCONCAT functionality in case your database server does not support it. The query must return exactly 2 columns document ID, and text to append. Document IDs can be duplicate, but they must be. All the text rows fetched for a given ID will be. Rows will be concatenated. For instance, if joined field query. Joined fields are only indexed differently. There are no other differences. Starting with 2. 0. It works similar to the ranged. Section 3. 8, Ranged queries. The range will be queried for and fetched upfront once. Payloads let you create a special field in which, instead of. Payloads are. custom integer values attached to every keyword. They can then be used. The payload query must return exactly 3 columns document ID keyword. Document IDs can be duplicate, but they must be. Payloads must be unsigned integers within 2. For reference, payloads are currently internally. Currently, the only method to account for payloads is to use. SPHRANKPROXIMITYBM2. On indexes with payload fields. SELECT docid, CONCATtag,tagid FROM tags ORDER BY docid ASC. SELECT id, tag FROM tags WHERE id start AND idlt end ORDER BY id ASC. SELECT MINid, MAXid FROM tags. Range query setup. Optional, default is empty. Applies to SQL source types mysql, pgsql, mssql only. Setting this option enables ranged document fetch queries see Section 3. Ranged queries. Ranged queries are useful to avoid notorious My. ISAM table locks when indexing. They also help with other less notorious issues, such as reduced. Inno. DB. to serialize big read transactions. The query specified in this option must fetch min and max document IDs that will be. It must return exactly two integer fields, min ID first. ID second the field names are ignored. When ranged queries are enabled, sqlquery. Note that the intervals specified by start. end. IDs that are. exactly equal to start or end from your query. The example in Section 3. Ranged queries illustrates that note how it. SELECT MINid,MAXid FROM documents. Range query step. Optional, default is 1. Applies to SQL source types mysql, pgsql, mssql only. Only used when ranged queries are enabled. Excel as a user input form to a sql database. We currently have several spreadsheets of data that are being updated by individual users, the problem is when we would like to provide reporting across all of these spreadsheets in one report. The data is updated biweekly with new data. We are currently maintaining an Excel Workbook which links to all of the workbooks and brings all of the data into one view. This one excel workbook is linking 1. We also have an issue when we need to add another workbook to this environment it takes a lot of time. I have been researching using SSIS Package to update the data in the tables, but in its basic form, it looks like I would need to delete the table and create a new table each time otherwise I am simply continuing to add additional rows tot he table each time. We are considering that it may be easier to 1. Import the Excel data into Sql tables and report out of Sql. Link the excel spreadsheets to sql so that the data can me maintained and updated and then the reports would be out of SQL. Please provide your thoughts and possible solutions to the above question.