Ad hoc queries vs stored procedures vs Dynamic SQL
- by Kristaps
Ad hock queries vs stored procedures vs Dynamic SQL. Can anyone say pros and cons?
Best regards, Kristaps
Search Results
Search found 6 results on 1 pages for 'kristaps'.
Page 1/1 | 1
-
-
Ad hock queries vs stored procedures vs Dynamic SQL
- by Kristaps
Ad hock queries vs stored procedures vs Dynamic SQL. Can anyone say pros and cons? Best regards, KristapsRead the article
-
Flexibility starting to develop applications and DB
- by kristaps
Hi! First of all I want to say some info for admins. This post can help to all DBA and developers. Hope You don't close this. I'm writing about widespread problem I'm writing master work and I want that You will had little time to answer my questions in my form. These questions are about db structures. Visit here: http://spreadsheets.google.com/embeddedform?formkey=dEhmOWFGb2twWVFreWJwWXp2U3c5a1E6MQ After I summarized results, I insert it in new post and developers can choose which structure to use to reach needed requirements developing new applications. I think that my test will help a lot of people. Best regards, KristapsRead the article
-
Ubuntu firefox: some web-pages stuck on loading
- by kristaps.skujins
Just installed Ubuntu 10.04 beta, installation went fine and all programs are working smooth. Just this one weird network problem. Some sites simply are not opening and loading forever. For example, google.com and youtube are working well, but ubuntu.com and many other are not opening at all, or are loaded partly. One thing i noticed is that on all of those pages on firefox status bar is message "Looking up for www.google-analytics.com" (or similar remote resources) message appearing all the time (even on this page, but it somehow has loaded and working). I should mention that i tried those pages to open on windows OS on this same machine, and they opened without problems. So i am guessing that it has to be some sort of network configuration problems on Ubuntu. What could cause such problem?Read the article
-
Crontab + .sh + php
- by Kristaps Karlsons
Hi. I'm trying to call a shell script every 5 minutes, witch executes php file under root. # crontab -l */5 * * * * /home/regularuser/call.sh permissions: -rw-rw-rw- 1 root root 162 Jun 6 23:40 call.php -rwxr-xr-x 1 root root 66 Jun 7 01:20 call.sh call.sh contents: #!/bin/bash php -q /home/regularuser/call.php echo "request processed" My problem is that my php file doesn't get executed via crontab. However, if I call call.sh - everything works perfectly. I'm new to crontab and shell scripting, so any advice/resources are welcome.Read the article
-
Regex for url formatting (www.domain.tld to anchors)
- by Kristaps
Hi. I'm currently developing a little browser-based Twitter widget. Currently, I'm stuck with getting the URLs to work. I'm kinda newbie, when it comes to regex (I know, how to get parts of a string, but this one – tough one). So, I need a regex that would search/replace www.domain.tld -> <a href="http://www.domain.tld">http://www.domain.tld</a> With/without http://, preferably. Any advice is welcome. Thanks.Read the article
