genenetwork3/sql, branch main GeneNetwork3 REST API for data science and machine learning http://git.genenetwork.org/genenetwork3/atom?h=main 2024-09-03T08:08:31+00:00 Use Jsonb for storing results. 2024-09-03T08:08:31+00:00 Alexander_Kabui 2024-09-03T08:08:31+00:00 urn:sha1:c34d75a29b7d144030542b9de4fd0e0d614303a9 Add sql file for creating llm db tables. 2024-08-29T08:06:07+00:00 Alexander_Kabui 2024-08-29T08:06:07+00:00 urn:sha1:57b4a4fd5bcb8a2b7f9af856d8f1212c0fbbe0da Add default timestamp and and primary key for Rating table. 2024-08-29T08:05:39+00:00 Alexander_Kabui 2024-08-29T08:05:39+00:00 urn:sha1:a45ab3e62df6e1dfcc6fff03916369fbdaf68ab8 Update copyright year and email. 2024-05-24T15:59:34+00:00 Alexander_Kabui 2024-05-24T15:55:49+00:00 urn:sha1:666461bcf6afc811e4c21dd23dbef2711a07049a sql: update: llm_db_update.sql: New file. 2024-05-24T15:38:18+00:00 Alexander_Kabui 2024-05-24T15:38:18+00:00 urn:sha1:f6dfb1a3d06b75ef74cfdc295bd7f30390d2a4d8 sql: caseattributes_audit.sql: New file 2022-05-27T12:02:25+00:00 BonfaceKilz 2022-05-18T09:48:10+00:00 urn:sha1:99a7781b6aab87c76e5bb2a67b421e3240d7c562 Create new table that stores edits related to case-attributes. sql: Remove database mapping code. 2022-02-11T06:29:24+00:00 Arun Isaac 2022-02-11T06:25:14+00:00 urn:sha1:d0c7631276223aae6954f7643abac262aa080e50 These tools have been greatly improved and moved to a new home at https://git.genenetwork.org/arunisaac/dump-genenetwork-database * sql/map-database.sh, sql/schema-from-in-db-documentation.org, sql/schema-original.sql, sql/schema.png, sql/schema.sql, sql/schema.svg: New files. Quote shell variables to prevent globbing 2022-02-11T02:52:36+00:00 Frederick Muriuki Muriithi 2022-02-11T02:45:24+00:00 urn:sha1:651c8ad9ae20ab52e7ab694c0caa9d92774b49b5 Quote the shell variables to prevent globbing and word splitting. Deactivate this check for the specific lines that require intentional word splitting Add SQL statement to update json_diff 2021-11-29T09:05:16+00:00 BonfaceKilz 2021-11-24T08:46:42+00:00 urn:sha1:9ab166a0d60b4a95c52599ab51ec97c19a2fff5b sql: Add documentation extracted from within the database. 2021-08-04T06:43:30+00:00 Arun Isaac 2021-08-04T06:43:30+00:00 urn:sha1:487e50e8f8304a65e7af3759c13256f921efb8be It turns out there is documentation of the database within the database itself. I have dumped that it into an org file. * sql/schema-from-in-db-documentation.org: New file.