Source Code in Database (SCID) is a technique of

code In communications and information processing, code is a system of rules to convert information—such as a letter, word, sound, image, or gesture—into another form, sometimes shortened or secret, for communication through a communication ...

manipulation where the code is

parse Parsing, syntax analysis, or syntactic analysis is the process of analyzing a string of symbols, either in natural language, computer languages or data structures, conforming to the rules of a formal grammar. The term ''parsing'' comes from Lati ...

d and stored in a

database In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases sp ...

. This allows many productivity-enhancing shortcuts which were otherwise not possible. A drawback of SCID systems is that code with syntax errors or other code that cannot be parsed, cannot be imported into a SCID system directly. One workaround for this is to comment out code that doesn't parse correctly.

visual programming In computing, a visual programming language (visual programming system, VPL, or, VPS) is any programming language that lets users create programs by manipulating program elements ''graphically'' rather than by specifying them ''textually''. A VP ...

tools may store programs as databases, since specialized

structure editor A structure editor, also structured editor or projectional editor, is any document editor that is cognizant of the document's underlying structure. Structure editors can be used to edit hierarchical or marked up text, computer programs, diagrams, c ...

are required to edit visual code.

Examples

IBM VisualAge VisualAge is a family of computer integrated development environments from IBM, which supports multiple programming languages. VisualAge was first released in October 1993 and was discontinued April 30, 2007 and its web page removed in September ...

Java Java (; id, Jawa, ; jv, ꦗꦮ; su, ) is one of the Greater Sunda Islands in Indonesia. It is bordered by the Indian Ocean to the south and the Java Sea to the north. With a population of 151.6 million people, Java is the world's List ...

is an example of an

integrated development environment An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of at least a source code editor, build automation tools a ...

implementing SCID features. A more recent example of Source Code in Database i
CodeOntology
an open source tool and RDF database of

source code that supports advanced

SPARQL SPARQL (pronounced "sparkle" , a recursive acronym for SPARQL Protocol and RDF Query Language) is an RDF query language—that is, a semantic query language for databases—able to retrieve and manipulate data stored in Resource Description F ...

queries, such as ''Select recursive methods'' or ''Select methods that compute the cube root of a double''.CodeOntology, ''Query examples''
http://codeontology.org/examples
Some other examples or discussions of SCID include: # http://www.c2.com/cgi/wiki?SourceCodeInDatabase # http://mindprod.com/project/scid.html # http://martinfowler.com/bliki/ProjectionalEditing.html Also, Eric & Mike Hewitt from PrecisionSoftware were working on a SCID in C# in 2014 .

References

Integrated development environments {{programming-software-stub

Examples

See also

References