Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Rahimullah Shaheen
+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.

On Tue, 11 Apr 2023 at 11:21, Steve Shin  wrote:

> +1
>
>
> 2023년 4월 10일 (월) 오후 8:34, Muhammad Zahid 님이
> 작성:
>
> > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >
> > On Tue, 11 Apr 2023, 6:43 am fatima raza, 
> wrote:
> >
> > > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> > >
> >
>


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Steve Shin
+1


2023년 4월 10일 (월) 오후 8:34, Muhammad Zahid 님이 작성:

> +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
>
> On Tue, 11 Apr 2023, 6:43 am fatima raza,  wrote:
>
> > +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
> >
>


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Muhammad Zahid
+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.

On Tue, 11 Apr 2023, 6:43 am fatima raza,  wrote:

> +1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
>


RE: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Kamlesh Kumar
+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.


Feedback and Report about using AGE 1.3

2023-04-10 Thread fatima raza
I wanted to extend my appreciation for the latest database changes.
I am glad to share positive feedback on the following upgrades after
evaluating them:

*1- Graph names with empty strings (") are no longer permitted:*
This enhancement avoids any potential misunderstanding or difficulties
caused by using an empty string as a graph name.
It supports improved data integrity and consistency throughout the system.

*2- Enable nested Cypher commands in EXPLAIN:*
The ability to have nested Cypher commands in the EXPLAIN capabilities is
quite useful for debugging and understanding the execution process of
complicated queries.
This enables users to refine their searches and improve query performance
overall.

*3. LICENSE and NOTICE - make sure:*
The presence of the LICENSE and NOTICE files reflects the project's
dedication to open source ideals and licencing compliance.
It represents the project's commitment to transparency and compliance with
the Apache Software Foundation's criteria.

Thank you for continuously improving the system and prioritizing
functionality, security, and user experience.

Regards,
Urooj Fatima Raza


Re: [VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread fatima raza
+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.


RE: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Kamlesh Kumar
+1

Installed and checked this release,
I checked out the following things changes and they are working fine,

checked plus-equal operator in the SET clause.
server no-more terminates from return exists(path)
using WITH and WHERE clause together works logically fine.
I faced no issues while using v1.3.0, Look good to me as well.


[VOTE] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread John Gemignani
Dear Apache Community,

This is an official vote for the Apache AGE release 1.3.0 for PostgreSQL 13.

To learn more about Apache AGE, please see http://age.apache.org/

Functionalities included and issues addressed in this release:
*
 Apache AGE 1.3.0 for PostgreSQL 13 Release Notes

 NOTE: Due to this being the first release for PostgreSQL 13, there is
no
 upgrade path from other versions.

 Implement CALL ...[YIELD] for cypher functions. (#630)
 Graph names with the empty string '' are disallowed. (#251)
 Fix typos at multiple locations. (#470)
 Fix Bug with CALL... [YIELD], clause ignores WHERE.
 Fix EXPLAIN to allow for nested cypher commands.
 Fix delete_global_graphs and add regression tests. (#336)
 Invalid labels now return NULL.
 Update CONTRIBUTING.md (#348)
 Fix null pointer on name compare. (#376)
 Fix Travis CI warning messages.
 Additional regression tests added for age_global_graph. (#341)
 Readme Added for AGE-JDBC-Driver. (#383)
 Updated volatility categories for many functions.
 Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
 Create complete graph function. (#342) (#662)
 Fix issue 317: Graph naming convention. (#349)
 Update SET clause to support assigning a map to a variable. (#468)
 Patch to address PR 203 that appears to be inactive. (#671)
 Add additional comments for create_graph function. (#582)
 Optimize age_exists function. (#586)
 Implement plus-equal operator in SET clause. (#638)
 Implement CI test for python driver. (#587)
 Move from travis CI to github actions for build. (#673)
 Update all driver CIs to Github actions.
 Fix build warnings. (#709)
 Updated Readme for drivers folder. (#642)
 Removed async from function definitions. (#680)
 Barbell graph generation (#648) and Barbell regress tests. (#708)
 Updated Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
 Fix WITH ignoring WHERE clause. (#646)
 Implement isEmpty() predicate function. (#710)
 Fix cypher function input argument checks. (#718)
 Fix Issue 693 - server termination from return exists(path). (#721)
 Update regression tests for cypher_with. (#725)
 Fix issue 733 - create_complete_graph() terminates the server. (#734)
 Prevent MATCH from following OPTIONAL MATCH. (#740)
 Fix property constraints against resolved variables. (#724) (#751)
(#701) (#747)
 Include invalid labels in reused variables. (#751) (#762)
 Fix update_entity_tuple to use correct CommandId. (#769)
 Remove check for scalar agtypes in unwind. (#736)
 Update PG13 CI workflows. (#775)
 Update readme and version for python driver. (#780)
 Update README.md
*

The git tag to be discussed and voted on:
https://github.com/apache/age/releases/tag/PG13/v1.3.0-rc0

The git commit hash:
commit 09e8cb4495f19badeb1aa20bf0990a874a120fbe

The release files for 1.3.0, can be found at:
https://dist.apache.org/repos/dist/dev/age/PG13/1.3.0.rc0/

Signatures used for AGE RCs can be found in this file:
https://downloads.apache.org/age/KEYS

The fingerprint of key to sign release artifacts:
4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045

For information about the contents of this release, see:
https://github.com/apache/age/releases/tag/PG13/v1.3.0-rc0

!!! IMPORTANT !!!
Please note that Apache REQUIRES the following information to be in your
response the the vote -

- If you are a binding vote, a PMC, then you MUST state it in your
response.
- You MUST state what you checked, to support your vote.

Please vote -

+1, Release this package as Apache AGE 1.3.0 for PostgreSQL 13.
  0, I won't get in the way of the vote.
 -1, Do not release this package because 

For example -

 +1 (Binding)
 Checked the following:
 - Signature and hash - check.
 - Tags and links - check.
 - LICENSE and NOTICE - check.
 - No unexpected binary files - check.

This vote will be open for 72 hours.

Thank you for your time.

John Gemignani


Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread John Gemignani
Dear Apache Community,

Since there are no objections, I am closing the [DISCUSS] thread and will
open the official vote for Apache AGE 1.3.0 for PostgreSQL 13 shortly.

Thank you all for your time!

John Gemignani

On Fri, Mar 31, 2023 at 2:43 PM John Gemignani 
wrote:

> Dear Apache Community,
>
>
>
> We would like to open a discussion for the Apache AGE release 1.3.0 for
> PostgreSQL 13.
>
>
>
> To learn more about Apache AGE, please see http://age.apache.org/
>
>
>
> Functionalities included and addressed in this release:
>
>
>
> Apache AGE 1.3.0 for PostgreSQL 13 Release Notes
>
> NOTE: Due to this being the first release for PostgreSQL 13, there is no
>
> upgrade path from other versions.
>
> Implement CALL ...[YIELD] for cypher functions. (#630
> )
>
> Graph names with the empty string '' are no more allowed. (#251
> )
>
> Fix typos at multiple locations. (#470
> )
>
> Fix Bug with CALL... [YIELD], clause ignores WHERE.
>
> Fix EXPLAIN to allow for nested cypher commands.
>
> Fix delete_global_graphs and add regression tests. (#336
> )
>
> Invalid labels now return NULL.
>
> Update CONTRIBUTING.md (#348 )
>
> Fix null pointer on name compare. (#376
> )
>
> Fix Travis CI warning messages.
>
> Additional regression tests added for age_global_graph. (#341
> )
>
> Readme Added for AGE-JDBC-Driver. (#383
> )
>
> Updated volitility categories for many functions.
>
> Fix issue 339 - entities in WHERE clause have wrong Expr. (#391
> )
>
> Create complete graph function. (#342
> ) (#662
> )
>
> Fix issue 317: Graph naming convention. (#349
> )
>
> Update SET clause to support assigning a map to a variable. (#468
> )
>
> Patch to address PR 203 that appears to be inactive. (#671
> )
>
> Add additional comments for create_graph function. (#582
> )
>
> Optimize age_exists function. (#586
> )
>
> Implement plus-equal operator in SET clause. (#638
> )
>
> Implement CI test for python driver. (#587
> )
>
> Move from travis CI to github actions for build. (#673
> )
>
> Update all driver CIs to Github actions.
>
> Fix build warnings. (#709 )
>
> Updated Readme for drivers folder. (#642
> )
>
> Removed async from function definitions. (#680
> )
>
> Barbell graph generation (#648 )
> and Barbell regress tests. (#708 )
>
> UPDATED Python Driver ANTLR 4.9.3 -> 4.11.1 (#706
> )
>
> Fix WITH ignoring WHERE clause. (#646
> )
>
> Implement isEmpty() predicate function. (#710
> )
>
> Fix cypher function input argument checks. (#718
> )
>
> Fix Issue 693 - server termination from return exists(path). (#721
> )
>
> Update regression tests for cypher_with. (#725
> )
>
> Fix issue 733 - create_complete_graph() terminates the server. (#734
> )
>
> Prevent MATCH from following OPTIONAL MATCH. (#740
> )
>
> Fix property constraints against resolved variables. (#724
> ) (#751
> ) (#701
> ) (#747
> )
>
> Include invalid labels in reused variables. (#751
> ) (#762
> )
>
> Fix update_entity_tuple to use correct CommandId. (#769
> )
>
> Remove check for scalar agtypes in unwind. (#736
> )
>
> Update PG13 CI workflows. (#775 )
>
> Update readme and version for python driver. (#780
> )
>
> Update README.md
>
>
> *
>
>
>
> The git tag to be discussed and voted on:
>
> https://github.com/apache/age/releases/tag/PG13/v1.3.0-r

[GitHub] [age] AhmedMo0 commented on issue #354: AGE Onboarding - Learn Postgres Basics Group 2

2023-04-10 Thread via GitHub


AhmedMo0 commented on issue #354:
URL: https://github.com/apache/age/issues/354#issuecomment-1502389341

   Summary of the first 3 chapters in 'Internals of PostgreSQL' book
   
   chapter 1:
   
https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-1-in-the-internals-of-postgresql-book-fl5
   
   chapter 2:
   
https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-2-in-the-internals-of-postgresql-book-img
   
   chapter 3:
   
https://dev.to/ahmedmohamed/a-quick-recap-for-chapter-3-in-the-internals-of-postgresql-book-1ap0


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-10 Thread Muhammad Taha Naveed
Hi,

I have tried to verify the changes to the best of my ability. Looks good to
me!

Great work.

Regards
Muhammad Taha Naveed

On Tue, Apr 11, 2023 at 1:17 AM Eya Badal  wrote:

> Looks good to me!!
>
> I checked the following:
>
> - Signature and hash - check.
> - LICENSE and NOTICE - check.
> - No unexpected binary files - check.
>
> Great Job!!
>
> Best,
> Eya
>
> On 2023/04/05 22:34:23 John Gemignani wrote:
> > Dear Apache Community,
> >
> > We would like to open a discussion for the Apache AGE release 1.3.0 for
> > PostgreSQL 12.
> >
> > To learn more about Apache AGE, please see http://age.apache.org/
> >
> > Functionalities included and addressed in this release are:
> >
> >
> > Apache AGE 1.3.0 for PostgreSQL 12 Release Notes
> >
> >
> > NOTE: Due to modifications to core tables, there is no upgrade
> > path from previous versions.
> >
> > Implement CALL ...[YIELD] for cypher functions. (#630)
> >
> > Graph names with the empty string '' are no longer allowed. (#251)
> >
> > Fix typos at multiple locations. (#470)
> >
> > Fix Bug with CALL... [YIELD], clause ignores WHERE.
> >
> > Fix EXPLAIN to allow for nested cypher commands.
> >
> > Fix delete_global_graphs and add regression tests. (#336)
> >
> > Invalid labels now return NULL.
> >
> > Update CONTRIBUTING.md (#348)
> >
> > Fix null pointer on name compare. (#376)
> >
> > Fix Travis CI warning messages.
> >
> > Additional regression tests added for age_global_graph. (#341)
> >
> > Readme Added for AGE-JDBC-Driver. (#383)
> >
> > Updated volatility categories for many functions.
> >
> > Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> >
> > Create complete graph function. (#342) (#662)
> >
> > Fix issue 317: Graph naming convention. (#349)
> >
> > Update SET clause to support assigning a map to a variable. (#468)
> >
> > Patch to address PR 203 that appears to be inactive. (#671)
> >
> > Add additional comments for create_graph function. (#582)
> >
> > Optimize age_exists function. (#586)
> >
> > Implement plus-equal operator in SET clause. (#638)
> >
> > Implement CI test for python driver. (#587)
> >
> > Move from travis CI to github actions for build. (#673)
> >
> > Update all driver CIs to Github actions.
> >
> > Fix build warnings. (#709)
> >
> > Updated Readme for drivers folder. (#642)
> >
> > Remove async from function definitions. (#680)
> >
> > Barbell graph generation (#648) and Barbell regress tests. (#708)
> >
> > Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> >
> > Fix WITH ignoring WHERE clause. (#646)
> >
> > Implement isEmpty() predicate function. (#710)
> >
> > Fix cypher function input argument checks. (#718)
> >
> > Fix Issue 693 - server termination from return exists(path). (#721)
> >
> > Update regression tests for cypher_with. (#725)
> >
> > Fix issue 733 - create_complete_graph() terminates the server. (#734)
> > Prevent MATCH from following OPTIONAL MATCH. (#740)
> > Fix property constraints against resolved variables. (#724) (#751) (#701)
> > (#747)
> > Include invalid labels in reused variables. (#751) (#762)
> > Fix update_entity_tuple to use correct CommandId. (#769)
> > Remove check for scalar agtypes in unwind. (#736)
> > Update PG12 CI workflows. (#776)
> > Update readme and version for python driver. (#780)
> > Update README.md
> >
> > *
> >
> > The git tag to be discussed and voted on:
> > https://github.com/apache/age/releases/tag/PG12/v1.3.0-rc0
> >
> > The git commit hash:
> > commit 01486efe5b8a2b316ae766299e6ec78b488fcff2
> >
> > The release files for 1.3.0, can be found at:
> > https://dist.apache.org/repos/dist/dev/age/PG12/1.3.0.rc0/
> >
> > Signatures used for AGE RCs can be found in this file:
> > https://downloads.apache.org/age/KEYS
> >
> > The fingerprint of key to sign release artifacts:
> > 4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045
> >
> > For information about the contents of this release see:
> > https://github.com/apache/age/releases/tag/PG12/v1.3.0-rc0
> >
> > Please verify the above links, files, and signatures in addition to
> sharing
> > your thoughts and feedback and if we can call for a vote.
> >
> > Thank you for your time.
> >
> > John Gemignani
> >
>


RE: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-10 Thread Wendel Fernandes
Nice work! Just checked:
- Ran regression tests
- Tested creating a graph with an empty name
- Tested searching for invalid labels
- Tried a null pointer comparison
- The WITH clause is no longer ignoring the WHERE clause
Everthing passed, so it all looks good to me.


RE: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Wendel Fernandes
Great work! It’s really nice that there’s now compatibility with PostgreSQL 13



Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 12

2023-04-10 Thread Eya Badal
Looks good to me!!

I checked the following:

- Signature and hash - check.
- LICENSE and NOTICE - check.
- No unexpected binary files - check.

Great Job!!

Best,
Eya

On 2023/04/05 22:34:23 John Gemignani wrote:
> Dear Apache Community,
> 
> We would like to open a discussion for the Apache AGE release 1.3.0 for
> PostgreSQL 12.
> 
> To learn more about Apache AGE, please see http://age.apache.org/
> 
> Functionalities included and addressed in this release are:
> 
> 
> Apache AGE 1.3.0 for PostgreSQL 12 Release Notes
> 
> 
> NOTE: Due to modifications to core tables, there is no upgrade
> path from previous versions.
> 
> Implement CALL ...[YIELD] for cypher functions. (#630)
> 
> Graph names with the empty string '' are no longer allowed. (#251)
> 
> Fix typos at multiple locations. (#470)
> 
> Fix Bug with CALL... [YIELD], clause ignores WHERE.
> 
> Fix EXPLAIN to allow for nested cypher commands.
> 
> Fix delete_global_graphs and add regression tests. (#336)
> 
> Invalid labels now return NULL.
> 
> Update CONTRIBUTING.md (#348)
> 
> Fix null pointer on name compare. (#376)
> 
> Fix Travis CI warning messages.
> 
> Additional regression tests added for age_global_graph. (#341)
> 
> Readme Added for AGE-JDBC-Driver. (#383)
> 
> Updated volatility categories for many functions.
> 
> Fix issue 339 - entities in WHERE clause have wrong Expr. (#391)
> 
> Create complete graph function. (#342) (#662)
> 
> Fix issue 317: Graph naming convention. (#349)
> 
> Update SET clause to support assigning a map to a variable. (#468)
> 
> Patch to address PR 203 that appears to be inactive. (#671)
> 
> Add additional comments for create_graph function. (#582)
> 
> Optimize age_exists function. (#586)
> 
> Implement plus-equal operator in SET clause. (#638)
> 
> Implement CI test for python driver. (#587)
> 
> Move from travis CI to github actions for build. (#673)
> 
> Update all driver CIs to Github actions.
> 
> Fix build warnings. (#709)
> 
> Updated Readme for drivers folder. (#642)
> 
> Remove async from function definitions. (#680)
> 
> Barbell graph generation (#648) and Barbell regress tests. (#708)
> 
> Update Python Driver ANTLR 4.9.3 -> 4.11.1 (#706)
> 
> Fix WITH ignoring WHERE clause. (#646)
> 
> Implement isEmpty() predicate function. (#710)
> 
> Fix cypher function input argument checks. (#718)
> 
> Fix Issue 693 - server termination from return exists(path). (#721)
> 
> Update regression tests for cypher_with. (#725)
> 
> Fix issue 733 - create_complete_graph() terminates the server. (#734)
> Prevent MATCH from following OPTIONAL MATCH. (#740)
> Fix property constraints against resolved variables. (#724) (#751) (#701)
> (#747)
> Include invalid labels in reused variables. (#751) (#762)
> Fix update_entity_tuple to use correct CommandId. (#769)
> Remove check for scalar agtypes in unwind. (#736)
> Update PG12 CI workflows. (#776)
> Update readme and version for python driver. (#780)
> Update README.md
> 
> *
> 
> The git tag to be discussed and voted on:
> https://github.com/apache/age/releases/tag/PG12/v1.3.0-rc0
> 
> The git commit hash:
> commit 01486efe5b8a2b316ae766299e6ec78b488fcff2
> 
> The release files for 1.3.0, can be found at:
> https://dist.apache.org/repos/dist/dev/age/PG12/1.3.0.rc0/
> 
> Signatures used for AGE RCs can be found in this file:
> https://downloads.apache.org/age/KEYS
> 
> The fingerprint of key to sign release artifacts:
> 4293 0603 8E35 AC05 4DBB  4B58 26B6 CD9D CD5B 0045
> 
> For information about the contents of this release see:
> https://github.com/apache/age/releases/tag/PG12/v1.3.0-rc0
> 
> Please verify the above links, files, and signatures in addition to sharing
> your thoughts and feedback and if we can call for a vote.
> 
> Thank you for your time.
> 
> John Gemignani
> 


Re: [DISCUSS] Apache AGE 1.3.0 Release for PostgreSQL 13

2023-04-10 Thread Mohamed Mokhtar
Greetings,
I have checked the release and found that it is good and liked that you are
working on making AGE compatible with the other versions so that it can be
used widely.
Here is the checklist I have taken a look into:

   - Installcheck passess all tests 24/24 passes.
   - Reviewed the typo changes and made a search about similar typos
   globally on github repository search and it passed (no similar found).
   - Signature & License and Notice & No binary files checked & passes.
   - Graph names with the empty string '' are no more allowed.
   - Running a session with multiple queries contains the age clauses.
   - Tested queries contain multiple data types returning queries

*FEEDBACK overall is nice work!*

Regards,
Mohamed Mokhtar,


Feedback on AGE 1.3.0

2023-04-10 Thread Amr Shams El-Deen
I have tested the recent updates on the database and wanted to provide a 
positive feedback on the following:

1- Graph names with the empty string '' are no more allowed:
This is a great enhancement as it prevent any confusion or issues with having 
an empty string as the graph name.

2- Fix EXPLAIN to allow for nested cypher commands: Allowing nested cypher 
commands in the EXPLAIN functionality is very useful to debug and understand 
the execution plan of complex queries. This helps optimize the queries and 
enhance the performance.

3- Invalid labels now return NULL:
Previously, invalid labels used to return an error which was not very user 
friendly. Returning NULL for invalid labels is a good improvement as it handle 
the errors smoothly without interrupting the user.

4- Prevent MATCH from following OPTIONAL MATCH
This update ensures that the MATCH query will not follow the OPTIONAL MATCH 
path which provides more control on the query behavior and results.

5- Signature and hash - check: Verifying the signature and hash ensure the 
integrity and security.
6- LICENSE and NOTICE - check: Including the LICENSE and NOTICE files is 
important for any software.
7- No unexpected binary files - check: No unexpected binary files guarantees a 
clean build.

Overall, these are valuable enhancements that improve the functionality, 
security and user experience of the database. Please keep the good work.

Regards,
Amr Shams