All Questions
Tagged with postgresql php
8 questions
2
votes
1
answer
157
views
Extracting authors and books from XML and inserting them into PostgreSQL
There is a tree of start folder, it's subfolders, their subfolders, etc. In each folder, subfolder, etc. there are the same structured XML files stored.
books.xml
...
- 23
0
votes
2
answers
3k
views
Best way to get the best performance of a large CSV upload in PHP
I am trying to upload a CSV file to a database which has around 800,000 rows. I am able to do this on my server with the following specs:
RAM: 4GB
Rows: 800,000
Time taken: 305 seconds
Usage: 15% RAM
...
2
votes
1
answer
1k
views
Managing PostgreSQL transactions for concurrency
I have a situation where I need to use PostgreSQL's serializable isolation level for transactions. This is for a table shared among multiple concurrent PHP processes. If the database runs into any ...
- 141
3
votes
1
answer
106
views
1
vote
1
answer
770
views
Adding new or existing tags to a blog post
I'm working on a simple blogsystem (for learning purposes, not to reinvent the wheel). In this system the user can add existing or new tags to a blogpost. I wrote a method to achieve this, but it's ...
- 307
6
votes
1
answer
2k
views
Generic method for database calls
Background
Breaking from MVC, I've implemented the following architecture:
POST/GET ➤ PHP ➤ Database Calls ➤ XML ➤ XSLT ➤ HTML
All database interactions are ...
- 1,927
2
votes
2
answers
205
views
Browser game project
I am working on a little browsergame project written in PHP and using PostgreSQL as DBMS. Now I'm not really lucky with the process started after a userlogin was successful.
Some info:
There are 3 ...
- 307
13
votes
1
answer
2k
views
Cross-language constants
I'm developing a web application that leverages multiple programming languages. The data flow resembles:
Browser » PHP » PL/SQL » XML » XSLT » XHTML + JavaScript » Browser
Using different languages ...
- 1,927