{"id":"https://openalex.org/W201950743","doi":null,"title":"Writing PostgreSQL Applications","display_name":"Writing PostgreSQL Applications","alternate_titles":[],"publication_year":2012,"publication_date":"2012-01-01","ids":{"openalex":"https://openalex.org/W201950743","mag":"201950743"},"language":"en","primary_location":{"id":"mag:201950743","doi":null,"is_oa":false,"landing_page_url":"http://momjian.us/main/writings/pgsql/writing_apps.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W201950743"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5053630147","display_name":"Bruce Momjian","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Bruce Momjian","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5053630147"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9560999870300293,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9560999870300293,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T13681","display_name":"Engineering and Information Technology","score":0.039400000125169754,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0007999999797903001,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/postgresql","display_name":"PostgreSQL","score":1.0},{"id":"https://openalex.org/keywords/object-relational-databases","display_name":"object-relational databases","score":0.878000020980835},{"id":"https://openalex.org/keywords/open-source-databases","display_name":"open-source database","score":0.9120000004768372},{"id":"https://openalex.org/keywords/jdbc","display_name":"JDBC","score":0.9860000014305115},{"id":"https://openalex.org/keywords/odbc","display_name":"ODBC","score":0.9879999756813049},{"id":"https://openalex.org/keywords/transactions","display_name":"transactions","score":0.6600000262260437},{"id":"https://openalex.org/keywords/stored-procedures","display_name":"stored procedures","score":0.753000020980835},{"id":"https://openalex.org/keywords/referential-integrity","display_name":"referential integrity","score":0.7670000195503235}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7589111328125},{"id":"https://openalex.org/C123327596","wikidata":"https://www.wikidata.org/wiki/Q212606","display_name":"Open Database Connectivity","level":5,"score":0.6805127263069153},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.6552455425262451},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.5925691723823547},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.590289831161499},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.565149188041687},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.5582437515258789},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.5219340324401855},{"id":"https://openalex.org/C2777002779","wikidata":"https://www.wikidata.org/wiki/Q42478","display_name":"Perl","level":2,"score":0.48561325669288635},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.40792039036750793},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1934775412082672},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:201950743","doi":null,"is_oa":false,"landing_page_url":"http://momjian.us/main/writings/pgsql/writing_apps.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4405068422","https://openalex.org/W1551176668","https://openalex.org/W2971641150","https://openalex.org/W192026941","https://openalex.org/W7051836049","https://openalex.org/W7160525900","https://openalex.org/W643082433","https://openalex.org/W2622097271","https://openalex.org/W7095668766","https://openalex.org/W1542145906"],"abstract_inverted_index":{"POSTGRESQL":[0,55,90,131],"is":[1,19,91],"an":[2,20],"object-relational":[3],"database":[4,74],"developed":[5,58],"on":[6,75],"the":[7,16,33,43,60,73,76],"Internet":[8,144],"by":[9],"a":[10,68,116,136,140],"group":[11,69],"of":[12,45,62,72,99,119,143],"developers":[13],"spread":[14],"across":[15],"globe.":[17],"It":[18,41,104,114],"open-source":[21],"alternative":[22],"to":[23,36,49,81,87,94,133],"commercial":[24,95],"databases":[25,46,96],"like":[26],"Oracle":[27],"and":[28,47,84,102,110,129],"Informix.":[29],"This":[30],"article":[31],"discusses":[32],"concepts":[34],"needed":[35],"write":[37],"applications":[38],"using":[39],"POSTGRESQL.":[40],"covers":[42],"purpose":[44],"how":[48],"communicate":[50],"with":[51],"them":[52],"from":[53],"applications.":[54],"was":[56],"originally":[57],"at":[59,64,135],"University":[61],"California":[63],"Berkeley.":[65],"In":[66],"1996,":[67],"began":[70],"development":[71],"Internet.":[77],"They":[78],"use":[79],"email":[80],"share":[82,88],"ideas":[83],"file":[85],"servers":[86],"code.":[89],"now":[92],"comparable":[93],"in":[97],"terms":[98],"features,":[100],"performance,":[101],"reliability.":[103],"has":[105],"transactions,":[106],"views,":[107],"stored":[108],"procedures,":[109],"referential":[111],"integrity":[112],"constraints.":[113],"supports":[115],"large":[117],"number":[118],"programming":[120],"interfaces,":[121],"including":[122],"ODBC,":[123],"Java":[124],"(JDBC),":[125],"TCL/TK,":[126],"PHP,":[127],"Perl,":[128],"Python.":[130],"continues":[132],"improve":[134],"tremendous":[137],"pace":[138],"thanks":[139],"talented":[141],"pool":[142],"developers.":[145]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W201950743","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
