Semantic search
SQLStore debug output
ASK Query
[[Database::+]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1014176')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
20
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(t1.p_id='1014176')
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
25
OFFSET
20
SQL Explain
| ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t1 | ref | s_id,p_id,s_id_2 | p_id | 4 | const | 350 | Using temporary; Using filesort |
| 1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | wikidb.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:1Query-Depth:1
Errors and Warnings
None
- Bibfilex
- Bibfilex is a bibliographic manager. It's useful for creating and managing archives of bibliographical items (books, articles, etc.) with possible attachments of any kind according to Biblatex structure and rules, but it can be used also with a word processor like Writer or Word. Bibfilex may create and manage files which are catalogs of many items – also thousands of them. A file of Bibfilex is a database of SQLite. In a Bibfilex file data are not stored according to Biblatex format, so it cannot be used as a bibliographic file in a Latex document. Anyway, Biblatex may export with a one-click functionality all or part of its content in Biblatex format file; this can be read directly with JabRef or used in a Latex document. At the same time, Bibfilex may import directly a JabRef database.
- BlueSpice
- BlueSpice extends MediaWiki and enhances it with useful features, in particular in the areas of quality management, process support, administration, editing and security. There are two editions available: BlueSpice free and BlueSpice pro. BlueSpice free is a free of charge wiki version. BlueSpice pro is the business-critical solution with comprehensive functionalities and a subscription for support and software maintenance.
- Boa
- A high-performance Web server for UNIX-like computers
- Bond
- BOND (building object network databases) is a rapid application development tool which allows you to develop GUI front ends to PostgreSQL databases. It uses XML to define widget layout and how to obtain information from databases. This project is designed to simplify the process of developing database applications for GTK.
- Bonddb
- 'bonddb' is an object orientated wrapper for PostgreSQL. It's a fast data abstraction layer C/C++ applications, to allow easy access to class objects. You can use existing PostgreSQL databases without any modification or additional tables needed in the backend. "bonddb' easily modifies rows in database fields without you having to construct sql statements or worry about refreshing existing datasets. It also lets you easily map your tables together in object to object relationships. Method calls aren't supported yet but they are being worked on.
- Burn 360
-
This is a candidate for deletion: Unclear licensing. The source files do not include any copyright information. The licence of the documentation on the website and included with the program is unclear. A copy of the GPLv2 is included with the program. Drw (talk) 09:20, 18 July 2018 (EDT)
This is a frontend to three programs - ffmpeg, vcdimager and cdrdao written in perl-gtk2.
It is designed to enable (as seperate processes)
Rip video tracks from VCD's
Encode from/to any format that ffmpeg supports (these are in a seperate file called opts)
Create a new VCD from MPEG's on hard drive.
- Business Integration Engine
- BIE is an free software integration system that makes it easy for organizations to exchange data with external trading partners regardless of their native applications. It is truly cross-platform since it written in Java.
- Castopod
- Decentralized podcast hosting software to run on your own server.
- CbMySQL
- 'cbMySQL' is a PHP class for creating, modifying MySQL databases and tables. For backup issues, you can export CSV data directly with only one class method. The MySQL object is easier to handle than PHP's built in functions, and you need not install anything like PEAR.
- Check Postgres
- check_postgres is a script for monitoring various attributes of your database. It is designed to work with Nagios, MRTG, or in standalone scripts.
- Coldstore
- ColdStore is a gigabyte-scale persistent object store which maps objects into a file (for persistence), can allocate objects in a minimal working-set of pages (for speed), permits library versions to change without a rebuild of the store, and permits application checkpoint/restart. Coldstore might be used to replace a database, cache highly structured objects, act as an OODB, make STL persistent, act as a Document Store for XML/SGML/HTML, create a MUD. Future projects include a virtual machine toolkit, ports of several languages, VW and byte-interpretive language workbench.
- Comanche Server
- Comanche is an extremely simple HTTP (web) server written entirely in Python. It does not use any of the many Python standard library modules related to HTTP serving, as it was initially written as a learning exercise. At present it does not support CGI or SSL and uses a simple fork-on-demand architecture, but is being actively improved.
- Common Lisp SQL
- 'CLSQL' is an SQL database interface for Common Lisp. It provides object-oriented and functional access methods to the underlying database, which can be one of MySQL, ODBC, PostgreSQL, or SQLite. It uses the Unified Foreign Function Interface (UFFI) and thus supports the CMU Common Lisp, Steel Bank Common Lisp, Allegro Common Lisp, OpenMCL, and Lispworks implementations.
- CrocoPat
- 'CrocoPat' is a tool for querying and manipulating relations. It is easy to use because of its simple query and manipulation language based on predicate calculus and its simple file format for relations. It is efficient because it internally represents relations as binary decision diagrams, a data structure that is well-known as a compact representation of large relations. CrocoPat is general, because it manipulates not only graphs (i.e. binary relations), but n-ary relations.
- Csv2mysql
- 'csv2mysql' is a Web-based tool that converts CSV files to MySQL tables. It asks for the location of the CSV file, type of the CSV file, and access info (server address, table name, username, and password) for the MySQL database, and lets users map the fields of a CSV file to the fields of a MySQL table.
- CsvCat
- Read multiple comma separated value files, such as exported from a spreadsheet or a database, and combine the output into a single file. Options are available to limit the columns included and to semi-intelligently skip headers.
- CsvUtils
- Transformation utilities for csv (or csv-like) generated rows. The standard csv module is very useful for parsing tabular data in CSV format. Typically though, one or more transformations need to be applied to the generated rows before being ready to be used; for instance "convert the 3rd column to int, the 5th to float and ignore all the rest". This module provides an easy way to specify such transformations upfront instead of coding them every time by hand. Two classes are currently available, SequenceTransformer and MappingTransformer, that represent each row as a list (like csv.reader) or dict (like csv.DictReader), respectively.
- Ctrlproxy
- 'ctrlproxy' is an IRC server with multiserver support. It runs as a daemon and connects to a number of IRC servers, then lets you to connect from a workstation and work as the user who is logged in to the IRC server. After you disconnect, it maintains the connection to the server. It acts like any normal IRC server, so you can use any IRC client to connect to it. It supports multiple client connections to one IRC server (under the same nick), so you can connect to IRC using your IRC nick, even if you have an IRC session open somewhere else. It supports logging (in the same format as the irssi IRC client), password authentication, and ctcp (in case no clients are connected).
- DBA Companion
- DBACompanion is a graphical administration tool for Oracle databases that lets you visualise the contents of a data dictionary. It lets you browse the data dictionary, drill down from one piece of information to related ones, generate SQL scripts based on data dictionary information, and customize all the SQL used by the tool.
- DBI Frame
- DBI::Frame is an extension of the standard DBI perl module, designed around MySQL, used to create and maintain frameworks for databases. It has query logging and a standardized interface for SQL statements like 'update' and 'insert' that doesn't require understanding SQL. Ideally, the user or developer shouldn't have to know SQL to be able to administer a database; this does require a special setup which isn't necessarily easy to create.
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.
The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.
