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
55
OFFSET
90
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
55
OFFSET
90
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
- Gq
- GQ is a GTK-based LDAP client that enables you to search and browse any LDAP V2- or V3-compliant server. You can also add, edit, and delete entries. Other features include a template builder, the ability to export a subtree or a whole server to LDIF, the ability to use any number of servers, and the ability to search based on a single argument or LDAP filter.
- Guile-dbd-mysql
- 'guile-dbd-mysql' is a MySQL database driver for guile-dbd.
- Guile-dbd-postgresql
- 'guile-dbd-postgresql' is a PostGreSQL database driver for guile-dbd.
- Guile-dbi
- 'guile'-dbi is a generic database interface for Guile that provides a way to use database drivers that are linked at run-time.
- Gurgle
- GURGLE (GNU Report Generator Language) is a software package for business applications. It produces database report listings from record and field information from a file. It uses the report to produce (La)TeX-formatted output, plain ASCII text, troff, PostScript, HTML, XML, or any other ASCII-based output format. It may be used for producing large bodies of text where small parts of the text are substituted with information from the database. GURGLE supports GNUSQL, PostgreSQL, MySQL and CA-Ingres databases. It also has an optional support for Guile.
- H-client
- The h-node project (https://www.h-node.org) is a website and database of computer hardware which works with fully free operating systems. h-client is a GTK+ graphical client which is able to detect the hardware inside the computer it's running on, and peripherals connected to it, and help you submit that information to the h-node project, along with your observations (eg: how well the hardware works with a fully free operating system, any special configuration required, etc).
- HOpla
- hOpla was dubbed as a GNU program by Richard Stallman in 2000. This software was developed by the maintainer of the GNU ToutDoux Project management tools.
History
hOpla was a link (command line) between XML files and SQL databases. It was intended for database administration, database structure modification, and the importing/exporting of data.
- HTTP-Replicator
- 'Replicator' is a replicating HTTP proxy server. Files that are downloaded through the proxy are transparently stored in a private cache, so an exact copy of accessed remote files is created on the local machine. It is, in essence, a general purpose proxy server, but especially suited for maintaining a cache of Debian or Gentoo packages.
- Halberd
- To cope with heavy traffic loads, web site administrators often install load balancer devices. These machines hide (possibly) many real web servers behind a virtual IP. They receive HTTP requests and redirect them to the real web servers in order to share the traffic between them. Halberd is a tool aimed at discovering real servers behind virtual IPs.
- Haskell Database Connectivity
- HDBC provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
- Health
- GNU Health is a program designed for hospitals, offering the following functionalities:
- Electronic Medical Record (EMR)
- Hospital Information System (HIS)
- Health Information System
- HealthBox
- HealthBox is a convenient way to manage health information. Instead of each app having to record inforamtion within it's own ecosystem, HealthBox creates a place for developers to centralize health information. Say you have a program that records your steps, one that monitors work outs, and a third program to track your nutrient intake. Typically, if you wanted to access your information, you'd have to use each respective service's interface. With HealthBox, those developers would be able to store all the information in one place, making it much easier for you to compare different health metrics, and share information between services.
- Hipercontracer
- High-Performance Connectivity Tracer (HiPerConTracer) is a ping/traceroute service. It performs regular ping and traceroute runs among sites and can export the results into an SQL or Non-SQL database.
- Homoeopim
- This is a toy homoeopathy software using a database, an expert system and a suit of CGI programs to search for homoeopathic remedies depending on symptoms entered. There is an iteration mode where questions are asked in a attempt to refine the search. This is an ongoing project, but with 47,000+ mapping entries between remedies and symptoms, it should be marginally usable.
- ICTFax
- ICTFax is free software white lable internet fax software that support email to fax , web to fax as well as fax to web and fax to email also it support integration with existing fax machines. ICTFax features both outbound faxing and inbound fax over internet through DID numbers
- IDempiere
- iDempiere Business Suite, also known as OSGi + ADempiere, is an open source Enterprise Resource Planning (ERP) software. It has also customer relationship management (CRM) and supply chain management (SCM) functions. The architecture of the iDempiere system is sophisticated allowing it to easily expand its functions while maintaining a simple and flexible state of the ERP business system with Application dictionary and Plug-ins.
- ISPConfig
- * Manage one or more servers from one control panel.
- Single server, Multiserver and Mirrored Clusters.
- No matter if physical server or virtual machine, ISPConfig just works.
- IceCat/RECAP
- RECAP is a browser extension that improves the experience of using PACER, the electronic public access system for the U.S. Federal District and Bankruptcy Courts. It also helps you contribute records to a public archive hosted by the Internet Archive and it shows you when free documents are available on the archive.
- ImgSvr
- ImgSvr is a Web image server, which allows users to browse digital images. It is a full HTTP server, which is specifically designed for image publishing.
- Inboxen
- Email service that allows a person to create an almost infinite amount of unique email addresses that the user can give to 3rd party websites. This lets the user have more control of their identity/privacy and keeps their personal email address free of junk.
- InfiniSQL
- InfiniSQL is a distributed in-memory NewSQL relational database management system (RDBMS). It excels at performing complex transactions which involve records on multiple server nodes. It is engineered around the actor model of concurrent programming, which enables unique scalability capabilities. InfiniSQL is currently in an alpha state, and the project is eagerly seeking developers, early adopters, and people who want to help build a community around it.
- Infovore
- Infovore is designed to merge large data sets such as Freebase and DBpedia, producing 100% valid RDF output at high speed because it uses the Hadoop Framework
- Interchange
- Interchange is a complete web-based application server It can create, automate and database-enable your web-site, and build on-line applications. It can be used as part of a standalone system or as part of a larger system. The Interchange demo application is ecommerce-based, so ecommerce has inevitably become its main use. The ecommerce demo and admin system supports sales, order processing, content management, customer service, and has been implemented for traditional retail sales, digital goods delivery, B2B parts re-ordering, non-commerce content management, auctions, order status checking, and supply chain management (among others). It can be integrated with payment processing services, ERP systems, point-of-sale systems, accounting systems, external content management systems, and Java-based application servers (among others). Interchange is made up of the following components: database abstraction layer, a generic templating system, transaction routing rules, a customer information object, a universal localization scheme, a security blackout definition, profiles, filters, a search language, and session management.
- Iplog
- This is a candidate for deletion: Links broken. No archive.org entry. Email to maintainer broken. Poppy-one (talk) 17:19, 5 August 2018 (EDT) iplog is a TCP/IP traffic logger. Currently, it is capable of logging TCP, UDP, and ICMP traffic. iplog is able to detect TCP port scans, TCP null scans, FIN scans, UDP and ICMP "smurf" attacks, bogus TCP flags, TCP SYN scans, TCP "Xmas" scans, ICMP ping floods, UDP scans, and IP fragment attacks. iplog is able to run in promiscuous mode and monitor traffic to all hosts on a network. iplog uses libpcap to read data from the network and can be ported to any system that supports pthreads and on which libpcap will function.
- JavaDICT
- This is a candidate for deletion: Cannot find download. Email to maintainer broken. Poppy-one (talk) 13:23, 6 August 2018 (EDT) JavaDICT is a server for the DICT protocol (RFC 2229), a TCP transaction-based query/response protocol that lets a client access dictionary definitions from a set of natural language dictionary databases. So far it is the only DICT server that lets you access dictionaries stored in a database (currently only PostgreSQL is supported).
- KLone
- KLone is a fully-featured, multiplatform Software Development Kit which allows dynamic pages to be written in C/C++ with usual <% code %> style. The pages can then be embedded, in compressed and/or encrypted form, into a single executable containing also KLone's HTTP/S server. Given its nature, it can be linked natively to any C/C++ library (database, XML, graphics, etc.), without an intermediate layer and it is expecially suited for low-resource and embedded systems.
- KNIME
- KNIME [naim] is a user-friendly graphical workbench for the entire analysis process: data access, data transformation, initial investigation, powerful predictive analytics, visualisation and reporting. The open integration platform provides over 1000 modules (nodes), including those of the KNIME community and its extensive partner network.
- KSS (Kinetic Style Sheets) framework
- KSS enables you write rich Ajax applications without having to code Javascript. It does this by using a CSS like resource, this is called a KSS file. All that you as a developer need to do is write files like these and implement server side Python. This Python package contains the Javascript engine and the server side infrastructure. The package forms the base for integration with specific web development frameworks. To see if there is support for your framework go to the KSS website.
- KSqlAnalyzer
- This is a candidate for deletion: 1. No files sources found cannot download. Reference: KSqlAnalyzer is a tool for easily accessing the data of a MS SQL database. It is made for developing and testing new SQL queries directly on the server. The functionality and look/feel are similar to SQL Query Analyzer. KSqlAnalyzer uses parts of the TDS library, and the editor uses parts of the KWrite source code because of its brilliant syntax highlighting.
- Kadet
- Kadet is a multi-threaded, multi-purpose server. It is highly extensible, well written, and has a great set of libraries including built-in scripting, a persistent database, object memory management, etc. It is very easy to develop. The server protocol is currently HTTP/1.1. SSL is supported via OpenSSL.
- KeePassX
- KeePassX is discontinued and recommends KeePassXC. Originally a GNU+Linux port of Keepass Password Safe, KeePassX is a cross platform encrypted database for your passwords, usernames, urls, comments, and attachments.
- Kexi
- KEXI is a visual database application builder tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. KEXI can be used for designing and implementing databases, data inserting and processing, and performing queries.
- Knoda
- Knoda is a KDE database-frontend for DBase, Firebird, MS Access, MySQL, Paradox, PostgreSQL, SQLite, and ODBC. Besides tables, views, and queries, it also handles forms and reports, which are scriptable via Python.
- Ldapvi
- 'ldapvi' allows a user to perform an LDAP search and update results using a text editor. It shows a summary of changes before committing them, and can rename entries.
- Led.pl
- 'led.pl' is a general purpose LDAP editor which allows editing of LDIF records or standard Unix flat file representations of LDAP databases using your favorite editor. It supports all of the maps defined by RFC-2307.
- Libre Lists
- Libre Lists is a Free and Open Source alternative to Microsoft Lists written in Python and Flask. It is a lightweight, self-hosted web application that works with SQLite databases. It also converts your SQLite database into JSON output or CSV files for the rest of your applications.
- LibreOffice
- LibreOffice is a comprehensive office suite. It contains a number of components: Writer, a word processor; Calc, a spreadsheet application; Impress, a presentation engine; Draw, a drawing and flowcharting application; Base, a database and database frontend; Math for editing mathematics. There are also a good and growing number of free software extensions and templates available. LibreOffice is a fork of OpenOffice.org, which is now called Apache OpenOffice. Because Apache OpenOffice hosts and recommends using proprietary extensions, we do not recommend using it.
- Librsync
- 'Librsync' provides checksum-based differencing. Currently its only application is rproxy, which provides diffs to previously cached Web pages and images in order to speed download time.
- Lighttpd
- 'lighttpd' is a secure, fast, compliant, and very flexible Web server which has been optimized for high-performance environments. It has a very low memory footprint compared to other Web servers, and it takes care of CPU load. It has an advanced feature set that includes FastCGI, CGI, Auth, Output-Compression, URL-Rewriting, and much more.
- LineControl Server
- LineControl remotely controls the connection of a GNU/Linux masquerading server using multiple clients. It takes care with the number of clients using the connection and decides, based upon this number, whether the connection should be up or down. The clients show connection time and throughput statistics. The package supports different connection types, such as analog modems, ISDN, or even cable modems and ADSL devices.
- Lingerd
- Lingerd is a daemon designed to properly close network connections from an HTTP server (ie Apache). This frees the server from doing the boring but time-consuming job of "lingering closes", and lets each process go on to the next connection immediately. As a result, Apache needs fewer processes to handle high loads. This saves memory, reduces kernel contention, and makes Apache more scalable.
- LiquidFeedback
- LiquidFeedback is an open-source software, powering internet platforms for surveys, proposition development and decision making. LiquidFeedback is an independent open source project. The software is published under MIT license by the Public Software Group of Berlin, Germany. The developers of LiquidFeedback have teamed up in the Association for Interactive Democracy to promote the use of electronic media for democratic processes.
- Luma
- 'Luma' is a graphical utility for accessing and managing data stored on LDAP servers. It is written in Python using PyQt and python-ldap. It features support for plugins and supports English, German, Portuguese, and Norwegian.
- MC
- MC is a C++ program that creates vector-space models from text documents that can be used for text mining applications. MC provides an efficient multi-threaded implementation that can process very large document collections. The MC program: 1. Recursively descends directories, finding text files 2. Processes files selectively through full regular expression matching of file names. 3. Builds a sparse matrix of word/token counts. The particular sprse marix format used is given here. 4. Processes any user specified text formats(email address or URLs) as a whole token through regular expression matching or FLEX definition. 5. Prunes vocabulary by word length and frequency 6. Excludes user specified stop words 7. Sets word vector weights according any of the txx, txn, tfn, tfx, lxx, lxn, lfn, lfx scaling schemes. 8. Writes all data structures to disk in the Compressed Column Storage format. The application does not have English parsing or part-of-speech tagging facilities or complete documentation
- MESICON
- Free software to assist in cataloguing challenging items in museum libraries (for example).
- Mail2web
- mail2web makes a mail archive, organised as RFC 5322 files in directories, accessible by HTTP.
- Mailfront
- 'mailfront' is a set of customizeable network protocol frontends for mail servers, replacing or supplementing the features available with the MTA software. It contains complete SMTP, QMQP, QMTP, and POP3 front-ends as well as an authentication module for IMAP. The mail delivery front-ends also contain internal address filtering features. Two SMTP back-ends are provided. One delivers mail to qmail-queue, mimicking most of the behavior of qmail-smtpd, with the addition of support for SMTP AUTH. The other rejects all SMTP commands if $SMTPREJECT is set, and execs its command line otherwise (in order to run the above program).
- Mandos
- The Mandos system allows computers to have encrypted root file systems and at the same time be capable of remote and/or unattended reboots. Wouldnââ¬â¢t it be great if you could have the security of encrypted root file systems and still have servers that could boot up automatically if there was a short power outage while you were asleep? That you could reboot at will, without having someone run over to the server to type in the password? Well, with Mandos, you (almost) can! The gain in convenience will only be offset by a small loss in security. The setup is as follows: The server will still have its encrypted root file system. The password to this file system will be stored on another computer (henceforth known as the Mandos server) on the same local network. The password will *not* be stored in plaintext, but encrypted with OpenPGP. To decrypt this password, a key is needed. This key (the Mandos client key) will not be stored there, but back on the original server (henceforth known as the Mandos client) in the initial RAM disk image. Oh, and all network Mandos client/server communications will be encrypted, using TLS (SSL).
- MaraDNS
- 'MaraDNS' is a fully functional DNS server supporting authoritative DNS, recursive DNS, and caching DNS. It is intended for environments where a DNS server must be secure and where the server must use the absolute minimum number of resources possible. Its security features include the use of a special string library which is resistant to buffer overflows and that the code, if started as root, mandates running as an unpriviledged user in a chroot() jail.
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.
