Hi all, We've published a new tutorial/cookbook page in pytables.org which is intended as a gentle guide to PyTables for users of SQL and relational databases. It describes the equivalent way in PyTables to perform most basic operations under SQL. You can find it at:
http://www.pytables.org/moin/HintsForSQLUsers The current contents of the document are: 1. Creating a new database 1. A note on concurrency under PyTables 2. Creating a table 1. Table descriptions 2. Column type declarations 3. Using a description 3. Creating an index 4. Altering a table 5. Dropping a table 6. Inserting data 1. A note on transactions 7. Updating data 8. Deleting data 9. Reading data 1. Iterating over rows 2. Reading rows at once 10. Selecting data 1. Iterating over selected rows 2. Reading seleted rows at once 3. Getting the coordinates of selected rows 4. A note on table joins 11. Summary of row selection methods 12. Sorting the results of a selection 13. Grouping the results of a selection Since it's a wiki page, you can add your own recipes and hints. If you think the page is missing some content you may want to see added, just request it in the users mailing list or create an empty section in the page. We hope that this page proves itself useful to new users coming from the relational world. We thank you for your contributions! Best regards, :: Ivan Vilata i Balaguer >qo< http://www.carabos.com/ Cárabos Coop. V. V V Enjoy Data ""
signature.asc
Description: Digital signature
------------------------------------------------------------------------- SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________ Pytables-users mailing list Pytables-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pytables-users
