- Pharo-dev - lists.pharo.org

Re: [Pharo-dev] Prepared Statements on PostgresV2?
by Stephan Eggermont Jan. 11, 2015

Jan. 11, 2015

Stef wrote: >Now I do not get it. > Did you port it to Pharo? I spend about a day evaluating it in 40272. I looked at three packages (and their two test packages). PostgresV3-Core handles the V3 protocol, makes a connection using a socket, provides a result set with rows, columns and text converters. I got a few problems in the unit tests, looks like something in the way floats are handled is different (PG3SocketReadStream>>parseFloatLength: and there is a method missing PG3SocketReadStream>>parseScaledDecimal PostgresV3-Pool provides a connection pool. I was able to use that to connect to a database, execute queries and get data out of it. Issues there are trivial: PG3Connection>>md5HashMessage: aString ^Smalltalk globals at: #MD5 ifPresent: [ :md5 | (md5 hashMessage: aString) hex asLowercase ] ifAbsent: [ WebUtils md5Digest: aString ] We don't have WebUtils, but we have MD5 Then there is PostgresV3-CodeMirror. In PG3SchemaMirror there are some overrides to select a different compiler (+parser) and code highlighter. That allows subclasses to have plsql functions as methods, using the PG3FunctionMirror. In Pharo, I couldn't easily find how to change the code highlighter in Nautilus. The PG3Compiler just changes the parser used to PG3Parser. The PG3Parser is a subclass from the squeak parser and so uses some things that work a bit different PG3Parser>>checkSyntaxFor: uses a cue instance variable. It is not a full plsql parser, relying on the database to check syntax. PG3SchemaChanges uses Toolbuilder to show a window with the differences between the functions in the database and those in the image and select which ones to change. Stephan

5 7

Essay Topics
by horrido Jan. 11, 2015

Jan. 11, 2015

As promised, here is my first list of essay topics. I would like to ask you to submit an essay on one of these topics. Multiple submissions are welcome; if they're good, they will all get published at Smalltalk Renaissance. I will edit the articles for grammar and style. You should look good after I'm done. There's no deadline, but obviously the sooner you can write them, the better. SRP is a fast-moving campaign. If you have other suggestions for essay topics, please let me know. Without further ado, here are the topics... Topic #1: How do modern IDEs, such as Eclipse and IntelliJ and Visual Studio, compare with the tried-and-true Smalltalk development environment? ----- Topic #2: It is the contention of some critics, including Robert Martin <https://www.youtube.com/watch?v=YX3iRjKj7C0> , that Smalltalk did not (does not?) address the needs of the enterprise. Present a counter-argument. Explain how Smalltalk can assist the enterprise in team development, in large-scale development, and in integrating with existing (typically Windows-based) infrastructures. Pay particular attention to the question of RDBMS usage, which is often critical in the enterprise. ----- Topic #3: Some critics complain that Smalltalk does not play well with existing file-based tooling. /Duh!/ Smalltalk is a "new" approach to IDEs and software engineering. We should be advancing this paradigm with new tooling, rather than falling back on the old again and again. Otherwise, things will never change for the better. Make a case for why we should embrace this change now, rather than waiting (for what?). Also, this webpage <http://thoughtstorms.info/view/smalltalkunix/view/smalltalk> poses an interesting argument against Smalltalk. Perhaps someone can tackle it. ----- Topic #4: In the age of multi-core processors and concurrency programming, how is Smalltalk addressing the concerns of developers? ----- Topic #5: How should we address the issue of compatibility (ie, fragmentation) among various implementations of Smalltalk? Does this issue hamper the creation of an ecosystem of libraries and shared code? -- View this message in context: http://forum.world.st/Essay-Topics-tp4797847.html Sent from the Pharo Smalltalk Developers mailing list archive at Nabble.com.

5 10

Prepared Statements on PostgresV2?
by Stephan Eggermont Jan. 11, 2015

Jan. 11, 2015

Stef wrote: >May be this is the time to improve this package :) >I'm sorry I have no DB experience. >As part of the consortium agenda for this year we have > - better ffi > - better db support Moving to Levente's PostgreSQLv3 and migrating that might be a better idea. He has been using it in production systems for a long time AFAIK. The code mirror is very interesting. Porting it needs someone with close access to Opal/old compiler knowledge. The way it works now in Squeak looks ideal for someone with a PostgreSQL background. Using a code browser to edit plsql, and having a directly mirrored smalltalk class for each table. http://forum.world.st/Status-of-PostgresV3-td4780110.html I have verified that the connection works and that I can get data out of postgres. Missing: - switch the code highlighter from smalltalk to one for plsql in nautilus. - connect to glorp - (later) add a real plsql parser (petitsql?) Stephan

4 5

Prepared Statements on PostgresV2?
by David Carlos Manuelda Jan. 10, 2015

Jan. 10, 2015

I've installed and tested PostgresV2 under pharo with the following doits Gofer new smalltalkhubUser: 'PharoExtras' project: 'PostgresV2'; configuration; load. (#ConfigurationOfPostgresV2 asClass project version: '2.4') load While it works good, it is missing a very important feature from both security and performance point of view: The prepared statements. As a brief, prepared statements are parameterized SQL statements that are loaded ONCE per connection instead of sending the whole query to DB every time, and also, they are parameterized, so it completelly prevents SQL injection, as the parameters are automatically 'detected' and scaped and/or handled accordingly without allowing in any case a parameter to alter the SQL meaning, which can happen by using regular SQL queries made by string concatenation. I browsed the class and did not find any prepare: method nor anything similar. Also, you can give a name to a SQL sentence, which makes the code much more readable without messing too much logic with SQL commands and string concatenation. An example is as follows: (supposing we have an instance variable connection, already initialized and connected via PGConnection class) Instead of: self connection execute: 'SELECT data FROM mytable WHERE name=''', anUser userName, ''';'. Would be something like this: self connection executePrepared: 'getUserData' with: anUser userName. And another suggestion could be something like: self connection prepare: 'getUserData' withSQL: 'SELECT data FROM mytable WHERE name=$1' Any plan for this to be implemented or any hint to other PostgreSQL class that already has it? David. P.S. I've written in my blog about this some time ago: http://stormbyte.blogspot.com.es/2012/06/programming-with-database-using.ht… if someone finds it useful.

6 11

[OT] Things people built with Smalltalk on Twitter: #thingsPeopleBuiltWithSmalltalk
by Torsten Bergmann Jan. 10, 2015

Jan. 10, 2015

If you know something built in Smalltalk then twitter it: https://twitter.com/hashtag/thingsPeopleBuiltWithSmalltalk?src=hash Lets make 2015 the "Anybody knows about Smalltalk" year ;)

1 0

TextMorph broken?
by Atlas Jan. 10, 2015

Jan. 10, 2015

Hi, I hate to bring this up, but it seems that TextMorph is broken: (1) The width of a TextMorph cannot be changed directly, only resetting the content (via #contents:) changes its width. (2) It's not possible to position the cursor past the last character with a point and click operation. (3) Moving the cursor past the last character with the arrow keys makes it disappear (even though it is positioned correctly). (4) It's not possible to change the font in the meta-menu. Is anyone else having similar problems? Any recommendations? All I need is a single line TextMorph that matches its width with the width of its text. I am using Pharo 3.0 (the most recent official version retrievable via the website). Thanks -- View this message in context: http://forum.world.st/TextMorph-broken-tp4798645.html Sent from the Pharo Smalltalk Developers mailing list archive at Nabble.com.

2 3

Need a PC users to get the PDF of
by stepharo Jan. 10, 2015

Jan. 10, 2015

Hi guys I would like to add Smalltalk, Objects and Design to our free book libraries and I do not have a pdf saver on mac for google book https://books.google.fr/books?id=W8_Une9cbbgC&printsec=frontcover&num=15&hl… Could one of you give a try? Thanks Stef

1 2

[ANN] Rewritten EventRecorder (now based on Spec)
by Torsten Bergmann Jan. 10, 2015

Jan. 10, 2015

Hi, I've rewritten, refactored, commented the Event Recorder. The most visible feature is that the UI is now based on Spec to fit Pharo style. Currently it can record and replay events. Saving and loading of events as *.tape files is still missing and (depending on time) will be added as a next step. With this tool we have the ability to record and exchange actions done in an image to reproduce bugs. The tool can also be used for demo purposes. As it is already usable I made it available in the config browser of Pharo 4. Attached is a screenshot, Code is on STHub [1]. Have fun T. [1] http://smalltalkhub.com/#!/~TorstenBergmann/EventRecorder

2 1

are senders and implementors broken in Pharo40?
by stepharo Jan. 9, 2015

Jan. 9, 2015

When I do senders of buildFrom: I get nautilus pointing a class but not the method? No time to fix it but we should avoid to integrate enh that breaks the browser like that. Stef

4 6

'(\w+s*){1, 3}' asRegex - image locks up in Pharo 3 & 4
by Paul DeBruicker Jan. 9, 2015

Jan. 9, 2015

Hi - In a workspace, if you inspect (or print, doIt, ... ) the following: '(\w+s*){1,3}'' asRegex The image will enter into a loop that the Cmd+. can't break out of. '(\w\s){1,3}' asRegex does not lock up the image. Including just one + or * causes the infinite loop when using a quantifier (the {} part). Does anyone know enough about how the Regex parts of the system to know where to look to fix it? Thanks Paul

2 1