Can I use Stored Procedure in PW?

[alvirtuoso]

How to execute stored procedures in pw?

[BitPoet]

Just use PW's $db object and pass the call statement to query() or (prepare()/execute() if you want to reuse the call or use bound parameters). PW's database object is just a wrapper around PHP's PDO class.

[LostKobrakai]

That's only part way correct. $db is a wrapper around php's mysqli class, whereas $database is serving a pdo object with the correct settings. 

[Doug G]

So out of curiosity, where does one find the documentation on $db and $database variables (other than lurking in forums)?  Is reverse-engineering the php files the only way to see what these variables do?

I have spent a lot of time in the processwire documentation area, but imho it's pretty much lacking in complete information.  This lack of documentation is what's keeping me from really getting into using processwire.

Also, is there a (long) one-page list of all processwire modules anywhere?

[cstevensjr]

Also, is there a (long) one-page list of all processwire modules anywhere?

On the modules page

http://modules.processwire.com/

Click "View All".  This list does have pagination, however it shows all published modules.  I don't think a continuous long list would be suitable on a web page.

[alvirtuoso]

So out of curiosity, where does one find the documentation on $db and $database variables (other than lurking in forums)?  Is reverse-engineering the php files the only way to see what these variables do?

I have spent a lot of time in the processwire documentation area, but imho it's pretty much lacking in complete information.  This lack of documentation is what's keeping me from really getting into using processwire.

Also, is there a (long) one-page list of all processwire modules anywhere?

I feel the same way regarding documentation. I'm coming from c# world and have done mostly desktop developing. I wanted to use asp.net for web developing because that's where my comfort zone is, but is more expensive to host plus it's latest open source version seems not apache or nginx friendly yet. The deployment documentation only discusses about azure deployment.  Correct me if im wrong, but I have searched around processwire regarding database and mostly are found here in forums. I thank you all for quick help from the community.

For the past 3 weeks, I've been playing with many php framework for my needs 1) quick prototyping DRY feature for small projects and found Yii2 that suites the most. Reading through pw discussions, people say that PW can do the same if not better so Im very much intrigued. Laravel was my 1st choice, but when I saw a long stack trace , things became clear to me why some aren't happy with it's performance. Great for small projects though. 2) I need something that's fast and found phalcon framework. It's very clean, neat, and I feel comfortable with it. I can see myself using it for future projects. 3) I need to have flexitbility with my framework. I thought of combing Slimphp(great for web services a.k.a. RESTful) with laravel's iluminate or with Fat-free php or components from symfony, aura, or library from Flourishlib 4) community plays a big role in every way. PW community seems more professional, adept, understands engineering besides developing, and helpful. I also noticed passion, respect, and loyalty.   The WOW factor often mentioned among pw newbies too.  Honestly, I'm learning more from pw forums than the provided documentaion, which is fine with me. while others would bash something about a framework they wrongly thought which can be entertaining at times just because their understanding of some design patterns are lacking. I myself was guilty once when taking over a project that was written in new language and design I've never seen. In the end, I learned more and grew. 

I'd like to see PW using composer, which I think sir Ryan included in his 2016 plan. Awesomeness! Happy Dance for me!