Graph of SQLDataFrame
  • *
  • *
  • *
  • *
  • *
  • *
  • |\
  • * |
  • | | *
  • | |/
  • | *
  • |/
  • *
  • *
  • *
  • *
  • |\
  • | *
  • | *
  • | *
  • | *
  • | *
  • * |
  • * |
  • | *
  • * |
  • * |
  • | *
  • | |\
  • | |/
  • |/|
  • * |
  • | *
  • |/
  • *
  • |\
  • * |
  • * |
  • |\ \
  • | * |
  • * | |
  • |/ /
  • * |
  • | *
  • |/|
  • | *
  • |/
  • *
  • *
  • *
  • *
  • | *
  • |/
  • *
  • *
  • |\
  • | *
  • * |
  • |/
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • |\
  • * |
  • * |
  • * |
  • * |
  • | *
  • |/
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • *
  • |\
  • | *
  • * |
  • * |
  • * |
  • * |
  • 909e7f6 (HEAD -> devel, origin/master, origin/devel, origin/HEAD) bump x.y.z version to odd y following creation of RELEASE_3_20 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2024-10-29 10:37:55 -0400;
  • 92c5fb4 (origin/RELEASE_3_20, RELEASE_3_20) bump x.y.z version to even y prior to creation of RELEASE_3_20 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2024-10-29 10:37:55 -0400;
  • ee7374d bump x.y.z version to odd y following creation of RELEASE_3_19 branch by J Wokaty <jwokaty@users.noreply.github.com> 2024-04-30 11:15:18 -0400;
  • 43a68ce (origin/RELEASE_3_19, RELEASE_3_19) bump x.y.z version to even y prior to creation of RELEASE_3_19 branch by J Wokaty <jwokaty@users.noreply.github.com> 2024-04-30 11:15:18 -0400;
  • 0f8da58 Fix NEWS by lshep <lori.shepherd@roswellpark.org> 2024-04-23 11:32:47 -0400;
  • 6616bea Merge branch 'devel' of git.bioconductor.org:packages/SQLDataFrame into devel by Qian Liu <qliu7@buffalo.edu> 2024-03-28 11:50:58 -0400;
  • 39a1751 Reimplementation of SQLDataFrame by Qian Liu <qliu7@buffalo.edu> 2024-03-28 11:17:22 -0400;
  • 4a69da1 (origin/RELEASE_3_18, RELEASE_3_18) bump version for release by Qian Liu <qliu7@buffalo.edu> 2024-02-09 14:15:00 -0500;
  • 767b55c address building error by mutate() by Qian Liu <qliu7@buffalo.edu> 2024-02-09 12:43:20 -0500;
  • 6eced9b bump x.y.z version to odd y following creation of RELEASE_3_18 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2023-10-24 11:14:30 -0400;
  • 2069924 bump x.y.z version to even y prior to creation of RELEASE_3_18 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2023-10-24 11:14:30 -0400;
  • 6905737 address checking error on nebbiolo2 linux by Qian Liu <qliu7@buffalo.edu> 2023-08-15 10:49:08 -0400;
  • 9b3e363 Merge branch 'master' into devel by Qian Liu <qliu7@buffalo.edu> 2023-06-28 10:33:28 -0400;
  • 49c7335 bump version for Bioconductor build by Qian Liu <qliu7@buffalo.edu> 2023-06-28 00:56:04 -0400;
  • 7e018f2 MAJOR UPDATE: by Qian Liu <qliu7@buffalo.edu> 2023-06-28 00:50:08 -0400;
  • 274d187 replace connSQLDataFrame() with dbcon() to wrap around dbplyr::remote_con() by Qian Liu <qliu7@buffalo.edu> 2023-06-23 15:12:43 -0400;
  • 9999fff redo the dbtable() function by wrapping higher level function dbplyr::remote_name() by Qian Liu <qliu7@buffalo.edu> 2023-06-23 14:52:01 -0400;
  • 21770a6 SQLDF embedding to GenomicRanges and SE objects. test script by Qian Liu <qliu7@buffalo.edu> 2023-05-24 10:55:35 -0400;
  • a6d85a2 bump x.y.z version to odd y following creation of RELEASE_3_17 branch by J Wokaty <jwokaty@users.noreply.github.com> 2023-04-25 11:10:43 -0400;
  • 3e21d5f (origin/RELEASE_3_17, RELEASE_3_17) bump x.y.z version to even y prior to creation of RELEASE_3_17 branch by J Wokaty <jwokaty@users.noreply.github.com> 2023-04-25 11:10:43 -0400;
  • 0a8f987 add rownames method per Herve's suggest, should be working inside SE or GRanges by Qian Liu <qliu7@buffalo.edu> 2023-04-03 15:27:42 -0400;
  • 10fa5ae bump x.y.z version to odd y following creation of RELEASE_3_16 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2022-11-01 11:20:02 -0400;
  • f59afdb (origin/RELEASE_3_16, RELEASE_3_16) bump x.y.z version to even y prior to creation of RELEASE_3_16 branch by J Wokaty <jennifer.wokaty@sph.cuny.edu> 2022-11-01 11:20:02 -0400;
  • 82d7dbf (origin/RELEASE_3_15, RELEASE_3_15) change version back to 1.10.3 for release after merging master by Qian Liu <qliu7@buffalo.edu> 2022-10-10 20:51:55 -0400;
  • 009f0f2 fix error for recursive calling of names() and colnames() in SQLDataFrame construction (validity check) by Qian Liu <qian.liu@roswellpark.org> 2022-10-10 19:09:07 +0000;
  • fe675e5 change version back to 1.10.2 after merging master by Qian Liu <qliu7@buffalo.edu> 2022-10-05 12:54:43 -0400;
  • 9db3a8f merge Herve's edits on concreting SQLDataFrame for virtual DataFrame by Qian Liu <Qian.Liu@roswellpark.org> 2022-10-05 16:43:24 +0000;
  • 85a30b5 fix test errors for union and rbind by Qian Liu <Qian.Liu@roswellpark.org> 2022-10-05 16:16:42 +0000;
  • 13eae1f Merge branch 'RELEASE_3_15' by Qian Liu <qliu7@buffalo.edu> 2022-09-22 22:00:03 -0400;
  • 28748d1 fix error in dbplyr, $op into $lazy_query, etc. by Qian Liu <qliu7@buffalo.edu> 2022-09-22 21:52:48 -0400;
  • 5ac673c bump x.y.z version to odd y following creation of RELEASE_3_15 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2022-04-26 15:56:34 +0000;
  • 7fc330b bump x.y.z version to even y prior to creation of RELEASE_3_15 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2022-04-26 15:56:34 +0000;
  • da7fdcb Merge pull request <a href="#5">#5</a> from hpages/master by Qian Liu <qliu7@buffalo.edu> 2021-11-24 12:43:02 -0500;
  • a91be38 Make SQLDataFrame a concrete subclass of virtual class DataFrame by Hervé Pagès <hpages.on.github@gmail.com> 2021-11-15 23:48:21 -0800;
  • 44f0403 bump x.y.z version to odd y following creation of RELEASE_3_14 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2021-10-26 16:52:26 +0000;
  • ed5bde5 (origin/RELEASE_3_14, RELEASE_3_14) bump x.y.z version to even y prior to creation of RELEASE_3_14 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2021-10-26 16:52:26 +0000;
  • 835d8c8 bump x.y.z version to odd y following creation of RELEASE_3_13 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2021-05-19 16:44:15 +0000;
  • f033f7b (origin/RELEASE_3_13, RELEASE_3_13) bump x.y.z version to even y prior to creation of RELEASE_3_13 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2021-05-19 16:44:15 +0000;
  • 5849521 (origin/RELEASE_3_12, RELEASE_3_12) bump version for release by Qian Liu <qliu7@buffalo.edu> 2020-11-23 17:18:29 -0500;
  • 0a90071 fixing mysql and bigrquery code in vignette by Qian Liu <qliu7@buffalo.edu> 2020-11-23 17:16:19 -0500;
  • d72ce17 Merge branch 'RELEASE_3_12' by Qian Liu <qliu7@buffalo.edu> 2020-11-11 11:55:57 -0500;
  • 58248a4 fix building error in saveSQLDataFrame and semi_join by Qian Liu <qliu7@buffalo.edu> 2020-11-11 11:53:15 -0500;
  • 16784f6 bump x.y.z version to odd y following creation of RELEASE_3_12 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2020-10-27 11:46:50 -0400;
  • 90a58ae bump x.y.z version to even y prior to creation of RELEASE_3_12 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2020-10-27 11:46:50 -0400;
  • 0d458da bump x.y.z version to odd y following creation of RELEASE_3_11 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2020-04-27 19:27:52 +0000;
  • c10c571 (origin/RELEASE_3_11, RELEASE_3_11) bump x.y.z version to even y prior to creation of RELEASE_3_11 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2020-04-27 19:27:52 +0000;
  • 0409b62 update mutate function documentation. Should support mutate(xx=NULL) to remove columns later.. by Liu <qi31566@5cg7171kq4.roswellpark.org> 2020-04-15 23:44:01 -0400;
  • 3ae7d93 bump x.y.z version to odd y after creation of RELEASE_3_10 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2019-10-29 13:43:36 -0400;
  • 6839d85 (origin/RELEASE_3_10, RELEASE_3_10) bump x.y.z version to even y prior to creation of RELEASE_3_10 branch by Nitesh Turaga <nitesh.turaga@gmail.com> 2019-10-29 13:11:43 -0400;
  • 2d4032c bump version by qian <qliu7@buffalo.edu> 2019-10-07 15:31:52 -0400;
  • 4e07c2a fixed R CMD check warning for S3 generic/method by qian <qliu7@buffalo.edu> 2019-10-07 15:31:20 -0400;
  • 4563f7a update vignette for Google BigQuery support! by qian <qliu7@buffalo.edu> 2019-10-07 15:01:09 -0400;
  • f24acdc BigQuery table is supported by SQLDataFrame constructor, and [, filter querying by qian <qliu7@buffalo.edu> 2019-10-07 14:20:24 -0400;
  • deca3ba bump version and update NEWS by qian <qliu7@buffalo.edu> 2019-10-01 11:27:28 -0400;
  • 9534cba updated Introduction in vignette by qian <qliu7@buffalo.edu> 2019-10-01 11:23:31 -0400;
  • 474f03f update makeSQLDataFrame for accommodation of MySQL, and support of both valid connection and credential args by qian <qliu7@buffalo.edu> 2019-09-30 17:32:42 -0400;
  • c053d1e update vignette for MySQL and and cross-database supports by qian <qliu7@buffalo.edu> 2019-09-30 16:37:58 -0400;
  • 56aafaa tweaks to address R CMD CHECK issues by qian <qliu7@buffalo.edu> 2019-09-30 12:22:38 -0400;
  • 3d0bced rename utility files by qian <qliu7@buffalo.edu> 2019-09-30 11:56:15 -0400;
  • 6943467 reorder utility functions by qian <qliu7@buffalo.edu> 2019-09-30 11:52:11 -0400;
  • 46a02d4 update Rd files for updated documentation by qian <qliu7@buffalo.edu> 2019-09-30 11:43:44 -0400;
  • d14c4be update documentation for saveSQLDataFrame by qian <qliu7@buffalo.edu> 2019-09-30 11:42:11 -0400;
  • 0cc676b remove copy= argument from join and union by qian <qliu7@buffalo.edu> 2019-09-30 11:38:24 -0400;
  • 1416e20 Updated documentation for union and rbind. by qian <qliu7@buffalo.edu> 2019-09-30 11:08:57 -0400;
  • ccf00b4 updated saveSQLDataFrame for preserving row indexes, also accommodate rbind results from mysql by qian <qliu7@buffalo.edu> 2019-09-25 17:31:16 -0400;
  • c1a002d updated documentation and script clean up by qian <qliu7@buffalo.edu> 2019-09-25 14:51:59 -0400;
  • e0d29a7 updated documentation in using *_join for MySQL tables by qian <qliu7@buffalo.edu> 2019-09-25 14:29:45 -0400;
  • 380143c cleaned and updated constructor function by qian <qliu7@buffalo.edu> 2019-09-25 12:47:02 -0400;
  • f90f301 tweak in saveSQLDataFrame by qian <qliu7@buffalo.edu> 2019-09-25 12:45:37 -0400;
  • 7721c22 aborted the idea of generic function for .join_union_prepare. by qian <qliu7@buffalo.edu> 2019-09-25 11:53:52 -0400;
  • 4c000d0 Merge branch 'mysql' of https://github.com/Bioconductor/SQLDataFrame into mysql by qian <qliu7@buffalo.edu> 2019-09-25 11:27:25 -0400;
  • b8709b6 remove old script by qian <qliu7@buffalo.edu> 2019-09-25 11:15:08 -0400;
  • fb8bc77 messages use ' instead of \" by qian <qliu7@buffalo.edu> 2019-09-25 11:13:21 -0400;
  • 0f78503 update test functions for alternative construction by qian <qliu7@buffalo.edu> 2019-09-25 11:05:55 -0400;
  • ba83cc7 updated save message, separately for MySQL and SQLite, valid and works! by qian <qliu7@buffalo.edu> 2019-09-24 16:25:31 -0400;
  • c4eb586 updated save message, separately for MySQL and SQLite, valid and works! by qian <qliu7@buffalo.edu> 2019-09-24 16:25:31 -0400;
  • 83dc7ea update man for some functions with updated arguments by qian <qliu7@buffalo.edu> 2019-09-24 15:32:47 -0400;
  • db95a84 updated SQLDataFrame() arguments, to take credentials by qian <qliu7@buffalo.edu> 2019-09-24 15:32:09 -0400;
  • 06f9ec5 saving of lazy join from same remote con is officially not supported! by qian <qliu7@buffalo.edu> 2019-09-24 14:37:27 -0400;
  • 5f0c4ef remove federated table after saving by qian <qliu7@buffalo.edu> 2019-09-24 12:30:19 -0400;
  • 34be8ba reorganized the join union function for mysql by qian <qliu7@buffalo.edu> 2019-09-24 12:02:32 -0400;
  • 1658319 saveSQLDataFrame saves SQLDF with simple operations! by qian <qliu7@buffalo.edu> 2019-09-23 15:59:10 -0400;
  • b70f869 now checks if mysql connection has write permission by qian <qliu7@buffalo.edu> 2019-09-23 15:42:25 -0400;
  • 3aa0f18 organizing .join_union_prepare functions. Need further test... by qian <qliu7@buffalo.edu> 2019-09-20 16:21:53 -0400;
  • 2dd8286 updated checks in saveSQLDataFrame, and mysql error message by qian <qliu7@buffalo.edu> 2019-09-20 12:53:27 -0400;
  • d78995a now using package environment to save MySQL connection and password info by qian <qliu7@buffalo.edu> 2019-09-19 11:33:23 -0400;
  • 0e39054 bug fixes: by qian <qliu7@buffalo.edu> 2019-09-18 11:41:52 -0400;
  • e1f0520 Added support of SQLDataFrame operations from local Connections. by qian <qliu7@buffalo.edu> 2019-09-13 14:11:29 -0400;
  • d1578a2 password not required for SQLDataFrame constructor. use NULL as default. by qian <qliu7@buffalo.edu> 2019-09-13 11:38:48 -0400;
  • 3161247 removed password argument from join/union functions, passed check! by qian <qliu7@buffalo.edu> 2019-09-13 10:38:12 -0400;
  • a1bac84 add new utility function to retrieve mysql pswd from env variable by qian <qliu7@buffalo.edu> 2019-09-12 17:26:24 -0400;
  • 0b9d0b1 saveSQLDataFrame retrieves remote pswd from env variable by qian <qliu7@buffalo.edu> 2019-09-12 17:15:03 -0400;
  • 53d9927 SQLDataFrame constructor save remote password as env variable by qian <qliu7@buffalo.edu> 2019-09-12 17:13:18 -0400;
  • 9461d7a add utility function to return pasted mysql info by qian <qliu7@buffalo.edu> 2019-09-12 16:21:42 -0400;
  • 8a7b7d4 Merge branch 'master' into mysql by qian <qliu7@buffalo.edu> 2019-09-12 12:33:11 -0400;
  • 4bce73c added a patch for "[" method for key column subsetting. by qian <qliu7@buffalo.edu> 2019-09-12 12:25:29 -0400;
  • 2d2b341 update the message for saveSQLDataFrame by qian <qliu7@buffalo.edu> 2019-09-11 17:28:07 -0400;
  • 71bf3e6 now saveSQLDataFrame supports MySQL by qian <qliu7@buffalo.edu> 2019-09-11 16:59:09 -0400;
  • e977670 separator changed from "\b" into ":" for composite key; add sql() for table name. by qian <qliu7@buffalo.edu> 2019-09-11 15:50:19 -0400;
  • ed4f3bd unified the .extract_tbl_from_SQLDataFrame_indexes(tbl, sdf) by qian <qliu7@buffalo.edu> 2019-09-11 11:29:14 -0400;